Formula Problem!!!

[MarkReddell]

I need a formula that will calc. the last row in a column to the Total row within a Table after the table sort with data entries below the last sorted row!!!

 

[LxQ]

bit confusing.. so if I understand correctly, let's say you have a table from row 1 through 10, then the total in 11. Then, let's say in row 12 you want to compare the entry in row 10 to row 11... I'm guessing the problem is that if you sort, the last row may move and the formula refers to some other row than 10..

I assume to total row, row 11 is stable.. so you work off that

=INDIRECT(ADDRESS(11,2,4,,)) --this would give you the value in row 11, column B..
=INDIRECT(ADDRESS(10,2,4,,)) --this would be row 10

you can also build in formulas.. for example, instead of 11, you can put ROW(B11) which returns 11.. this is helpful if you copy the formula because it updates..

consequently, you can use ROW(B10) or ROW(B11)-1

 

[MarkReddell]

You are close! I sort by date for my reports. So, if I have a month date entries say for the month of Aug. which has 31 days, So in row 32 in my table would by for my Total row. If I were to sort by date the week of aug. 14-20 I want to write a formula in the Total Row that will return either the first row (WHICH WOULD BE AUG 14) or the last row (WHICH WOULD BE AUG. 20) of a sorted table only with all other data entry rows before & after the selected rows sorted out!!! Thanx for ALL your help!!!

 

[Joe4]

Duplicate: http://www.mrexcel.com/forum/showthread.php?t=576144

Please do not post the same question multiple times. All clarifications, bumps, or directly related follow-ups should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).