Hi, I've never actively used PivotTables or PivotCharts before, but have something very specific I want to try and do - hoping I could get pointed in the...

The starting value is 1000. If it is up 5% it would equal 1050. If I still want to keep my starting value in B4 what equation would I use to find the value...

I am entering information into an excel sheet and it bounces to the top of the worksheet and overrites information. This sheet has alot of formulas in it...

This is exhausting. I've surfed and surfed for answers. None! I have a previous post, just two or three down from this one ("Need help with formula), but...

I have a single 23,000 lines of VBA code Excel application (with 28 sheets with lots of data), which migrated from 2007 to 2010 without presenting any...

Probably a very simple question but... i use excel for bookkeeping and therefore have sheets of jan to dec with formulas in certain cells to work out VAT...

I have created a sum using getpivotdata to add 2 items in a pivot table. The first one works fine but when I try to copy it down the column, I get the same...

I have a large spreadsheet that is downloaded from another site. Is there a formula to group rows from 'header' to next header? I need to group 4 rows and...

Does anyone have any suggestions for the above subject line? We are having issue after converting to 07 with out conditional formatting. It is saying there...

I have large data entry spreadsheets (10-20 columns) often with one or two cells duplicated in the next row down. Is there a shortcut key which will...

I've recently switched computers and now my Microsoft Excel does not display the formula bar at the top of the page. It is much easier to edit long formulas...

Any help with the following is much appreciated. I have a set of data with unique ID numbers. There are multiple entries for each Unique ID with different...

I'm looking for a formula to convert time to a decimal Example: (6:15 + 5:45 + 2:15 + 1:25) * 3 = equals amount due in dollars (whole number) times listed...

I would greatley appreciate assistance with how to count the following: If range d2:d350 contains varied account numbers, and range f2:f350 contain a...

How do I find out what macro and the code assigned to a specific button in an Excel worksheet? I can view all the macros assigned to the workbook, but it...

Dear All I have lot of work sheets in one excel work book , i want all work sheet in one sheet. is there any possiblities to move all sheet to one sheet...

I am looking for a function to find money values within certain ranges and within certain date ranges: Here is what the data I will get will look like A ...

I have a VLOOKUP. The wizard box shows the formula result but it appears as "0" in the cell. Formatting is general. Why doesn't the result display in the...

Dear Gurus, Trying to change the Reference Cell of the Offset funtion, but unfortunately, can not succeed in doing so. For example, 1 2 A 100 ...

I created a simple Concatenate Function C2, " ", D2, " ", E2 Which worked e.g. Big Red Apple I filled that down