Loop to Find the Max Value of Data in Multiple Columns
Hello,
I am trying to create a Loop that will analyze dates in columns D?, E?, F?, G?, and place the most recent date in H?.
So pretty much there are dates in 4 columns, and I need to find the most recent date for every row in the data set.
I know I could probably use =MAX(D2, E2, F2, G2), but how could I turn this into a loop, and make it work for the visible cells after the data has been filtered.
Thanks,
Nick
Hi, Nick,
maybe something like this for a start (SpecialCclls(xCellTypeVisible) might be used when data is filtered):
Ciao,
Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Another method...
Please Login or Register to view this content.
Last edited by AlphaFrog; 12-12-2012 at 03:43 PM.
HaHoBe,
That seems to work fine for placing the values in the same worksheet. What if I wanted to place them in a different worksheet? Placing a With Worksheets("WORK").Range("G1") doesnt work.
Hi, Nick,
that line woud always overwrite the data to show only the last entry. If you want every max listed:
Ciao,Please Login or Register to view this content.
Holger
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks