Find Minimum value in Column if cell in another collumn doesnt contain

**ciaron178** · 12-11-2018, 10:38 AM

Hello,

Im looking for a formula to find the Minimum value (in this case the oldest date) in Collumn G, if the cell in column B doesnt contain Not Here (but the column will still contain a varity of other text)

Thank you in advance.
Ciaron178

Edited the above to be more clear.

**Phuocam** · 12-11-2018, 10:48 AM

Try:

=AGGREGATE(15,6,G2:G10/(G2:G10<>"")/(B2:B10=""),1)

**ciaron178** · 12-11-2018, 11:02 AM

So i Should have said that Column B will still always contain other data

**Phuocam** · 12-11-2018, 11:10 AM

=AGGREGATE(15,6,G2:G10/(G2:G10<>"")/ISERROR(SEARCH("Not Here",B2:B10)),1)

**ciaron178** · 12-11-2018, 11:17 AM

perfect thank you!

Find Minimum value in Column if cell in another collumn doesnt contain

LinkBack

Thread Tools

Rate This Thread

Display

Find Minimum value in Column if cell in another collumn doesnt contain

Re: Find Minimum value in Column if cell in another collumn doesnt contain

Re: Find Minimum value in Column if cell in another collumn doesnt contain

Re: Find Minimum value in Column if cell in another collumn doesnt contain

Re: Find Minimum value in Column if cell in another collumn doesnt contain

Thread Information

Users Browsing this Thread

Similar Threads

Creating a collumn based on a diffrent collumn with a formula applied

[SOLVED] Find Minimum value in column and return with L1,L2,L3 …..

Find minimum value(s) in column and gather corresponding name from another column

Pivot Table: Minimum doesnt display milliseconds

[SOLVED] Find a collumn in a dynamic sheet and select the entire collumn

Loop Macro to Find Minimum Date for Column Data

[SOLVED] Minimum qualifiers to Find (VBA) the actual last used Row, Column

Bookmarks

Bookmarks

Posting Permissions