How can i change this so my lastrow= is the lowest cell of A B or C?
Something like tis
Many ThanksPlease Login or Register to view this content.
How can i change this so my lastrow= is the lowest cell of A B or C?
Something like tis
Many ThanksPlease Login or Register to view this content.
Last edited by Directlinq; 06-19-2009 at 10:27 AM.
Good morning Directling
If your sheet has data columns D onwards, you will need to check A, B and C and determine which is the largest. If you have no data in D onwards, then something like this should work :
HTHPlease Login or Register to view this content.
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
Have a look at.
There may be something in there at helps.HTML Code:
If not let me know.
Would This Do It.
Please Login or Register to view this content.
Last edited by D_Rennie; 06-19-2009 at 10:26 AM.
Unfortunatly i have data in D onwards
How would i go about checking whether A B or C is higher?
Many Thanks
Wow excellent Thanks so much
Works great
Didnt see it was solved.
I done this as an example.
Im Stoked I could HelpPlease Login or Register to view this content.
Last edited by D_Rennie; 06-19-2009 at 11:01 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks