Articles & Videos
A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.
I have a basic spread sheet. I have attached a sample.
I would like to sum column c if column b has the word "Swings" in it AND the date in column a is between 1-1-2017 and 1-31-2017
I cant …
I have a spreadsheet that contains dates in Column G. If that date in Column G is greater than 7 or = to the present date, then in Column H when clicked, you are prompted with a "Yes" …
I have a spreadsheet that has a model type in column A and could be any number of serial numbers in column B for that model. I need those broken up in separate rows and the model copied down as well …
I would like to find a closest match by comparing two columns in Excel. I tried VLOOKUP and MATCH but they return only if it is an exact match. Is there a way to find a closest match? I am …
In the attached spreadsheet, I have 2 tabs. The first tab is what I cut and paste my inventory into. In Column "M", I want to return from a list in the second tab the value for MIN, or the minimum …
Hello - one of my users came to me with this issue. Their spreadsheet starts spacing the rows and changing the highlighting colors after row 85, and they don't know why. I can't see why either and …
I have a customer with 20 computers (Windows 10) connected to a SBS 2011 Server. They all run Office 2013 and they all have random issues with Excel locking up when they have multiple spreadsheets …
Is there a way to sort a block of data automatically from one part
of the sheet to another.
I have attached a spreadsheet which was sorted manually
To be sorted on column C
im very simply trying to sum up 4 numbers in a spreadsheet. and no matter how i do it. excel does not add them up correctly.
if you look at the picture im trying to have excel sum up …
I want to create formula to check that in each row if the data is all the same in each cell then it should say "all Ok" if not then should say need attention. I want to check cell from column D …
This formula might look strange and basically surely does not work:
its target would be to place a formula which determines the range …
Hello Experts -
I have a macro that I'd like to run. All this macro does is simply highlight the row and column you are on for easy viewing. After I save the code and go back to the …
I am using MS Excel 2016 and want to set things up so that conditional formatting is applied to "cell A" following a change in "cell B". So far so good, but there should be a time delay (e.g. 1 week) …
I have been asked to create a spreadsheet which contains a list of costumers and their orders.
The customer can choose from a number of different fruits, such as apple, pear etc.
So I have a spreadsheet that uses a lot of lookups/Index-Match type stuff. I have been experimenting with different macros to process my data and have had success in doing so. Problem is that it …
I have created a Power Pivot Chart and added a Chart Title label to the chart.
I then ensure the Chart Title box is selected, I go to the formula bar and type in the location of …
: Microsoft Office Collaborate for free and online versions of Microsoft Word, Excel, Powerpoint, OneNote, Onedrive , Email, Calendar etc. In short we can say that Microsoft office is a suite of servers, applications and services developed by Microfoft. But sometimes people faces problems .
I need help to build a macro that will allow to cut a value from the selected active cell in active worksheet (ie "sheet1") to another worksheet (ie. "sheet2") but paste in specific cell? …
I have a list a IP address' that correspond to specific locations. As IP address' go however, there are variations in the last digits. For instance, the Albuquerque office has IP address 220.127.116.11 …
I have been provided an excel sheet from my management.It has 2 sheets.The first has all the raw data and the second has the summarized view of the first with all the formula.
Iam trying to …
Can you please have a look on the attached file, I need to compare Payment terms which values 4 characters long ones as blue marked on the attached picture:
As you can see …
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
I got helped my Martin Liss for this post : Merging-Splitting-Multiple
Now I would like to apply this…
I've written a simple script that grabs the contents of the active cell and assigns it to a var here:
var valueactivecell = activecell.getValue();
I'd also like to grab the contents …
There is no back button, no CTRL+Z when a script is run through Excel. Once you run a macro, that’s it, there is no going back. You pose the risk of losing all your raw data if it isn’t backed up. …
Wayne Taylor (webtubbs)
3,600 points this week
Lynn Haven, Florida, United States
2,000 points this week
2,000 points this week
Walvis Bay, Erongo, Namibia
1,400 points this week
Rey Obrero (Capricorn1)
Seattle, United States
1,000 points this week