Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lastrow
HELP!!! I'm doing a formula and I'm trying to get it to look at the last row
in column B every time I paste information in the worksheet I have included my formula. All I see is the VB But I need it in formula. I need instead of going to 4005 I need it to go to the end of the last row. =MAX(SUMPRODUCT(($B$2:$B$4005=B2)*($A$2:$A$4005A2-1)*($A$2:$A$4005<A2+1)*($E$2:$E$4005))) Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lastrow
How about something like...
=MAX(SUMPRODUCT(--($B$2:$B$65000=B2),--($A$2:$A$65000A2-1),--($A$2:$A$65000<A2+1),--($E$2:$E$65000))) ??? -- Hope this helps. Thanks in advance for your feedback. Gary Brown "Mr. Damon" wrote: HELP!!! I'm doing a formula and I'm trying to get it to look at the last row in column B every time I paste information in the worksheet I have included my formula. All I see is the VB But I need it in formula. I need instead of going to 4005 I need it to go to the end of the last row. =MAX(SUMPRODUCT(($B$2:$B$4005=B2)*($A$2:$A$4005A2-1)*($A$2:$A$4005<A2+1)*($E$2:$E$4005))) Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lastrow
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HELP Lastrow Range | Excel Discussion (Misc queries) | |||
Defining Named Range for Lastrow in a specific column | Excel Discussion (Misc queries) | |||
LastRow of Data | Excel Worksheet Functions | |||
Type mismatch on LastRow | Excel Discussion (Misc queries) | |||
Lastrow in Range | Excel Discussion (Misc queries) |