Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula needed to show blank when values do not appear
I have a spreadsheet where by column H, and every third column after that up
to AO7, shows an amount of growth from the starting figure that appears in column E (the growth shown in each column is NOT cumulative). At the end of the spreadsheet, I have column which needs to show the last growth figure entered for each row. However, not all rows will show it's last figure in the same column, i.e. the last growth figure for row 11 might appear at K11, while the last growth figure for row 19 might appear at T19. All cells prior to the last populated cell should be populated. I have entered a formula to achieve this, which works ok: =INDIRECT(CONCATENATE("R",ROW(),"C",((COUNT(H11,K1 1,N11,Q11,T11,W11,Z11,AC11,AF11,AI11,AL11,AO11))*3 )+5),FALSE) However, where there is no growth amount shown on the spreadsheet (in any of the cell refs displayed in formula above), I need the value in the last column to show nothing (blank). At the moment it shows the value of column E (the starting figure upon which the growth figures are based) but this will distort my figures. Any ideas? Thanks in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting 0 values to show blank cells | Excel Discussion (Misc queries) | |||
Formula Needed for Corresponding Blank Cell | Excel Worksheet Functions | |||
IF formula returns blank cells--only want values to show | Excel Worksheet Functions | |||
Zero values to show blank | Excel Worksheet Functions | |||
zero values in charts-don't want to show as zero, but as blank | Excel Discussion (Misc queries) |