| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivotting - Formula w/ Varying Column
I am using a Pivot Table and I have some formulas to rank the top numbers in
each column. My problem is - at times there will be 7 columns and other times 3 or 4, so the "Grand Totals" column moves. Here is my formula:RANK(J6,$J$6:$J$500,0)+COUNTIF(J6:$J$6,J6)-1 But the the reference to J may need to be changed. Basically: If J5 ="Grand Total" use the above formula, but if i5="Grand Total" then use RANK(i6,$i$6:$i$500,0)+COUNTIF(i6:$i$6,i6)-1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivotting? Transposing? Normal Forming? Crosstabbing? | Excel Discussion (Misc queries) | |||
| varying column width by row | Excel Discussion (Misc queries) | |||
| linking one column or varying range to another column using same f | Excel Worksheet Functions | |||
| Varying column widths | Excel Discussion (Misc queries) | |||
| Varying column width in a column chart | Charts and Charting in Excel | |||
Threaded Mode
