Hello everyone,
Please take a look at this formula and see what's wrong:
x=Application.WorksheetFunction.LOOKUP(2,1/(WorksheetFunction.COUNTIF(Sheet8.Range("B3:B351"),"">"" & Sheet8.Range("B3:B351")=0),Sheet8.Range("B3:B351"))
Thank you.
Hello everyone,
Please take a look at this formula and see what's wrong:
x=Application.WorksheetFunction.LOOKUP(2,1/(WorksheetFunction.COUNTIF(Sheet8.Range("B3:B351"),"">"" & Sheet8.Range("B3:B351")=0),Sheet8.Range("B3:B351"))
Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks