Brittany Wilkey
662 followers
662 followers
Brittany's posts
Post has attachment
I have linked to a spreadsheet with the raw data that has a Date 1 and Date 2, I want the smallest Date 1 returned (that is not a 0) so long as Date 2 is blank

The formula I tried

=ArrayFormula(min(if(and(isblank(if(A2='Raw Data'!A:A,'Raw Data'!C:C)),if(A2='Raw Data'!A:A,'Raw Data'!B:B)>0),if(A2='Raw Data'!A:A,'Raw Data'!B:B))))

Post has attachment
I have linked to a spreadsheet with the raw data that has a Date 1 and Date 2, I want the smallest Date 1 returned (that is not a 0) so long as Date 2 is blank

The formula I tried

=ArrayFormula(min(if(and(isblank(if(A2='Raw Data'!A:A,'Raw Data'!C:C)),if(A2='Raw Data'!A:A,'Raw Data'!B:B)>0),if(A2='Raw Data'!A:A,'Raw Data'!B:B))))

Post has shared content
Can anyone help with this? For some reason, my post on Excel Experts keeps disappearing.
#excel #formulahelp #helpmeplz﻿
I am back with another issue! I have linked to a spreadsheet with the raw data that has a Date 1 and Date 2, I want the smallest Date 1 returned (that is not a 0) so long as Date 2 is blank

The formula I tried

=ArrayFormula(min(if(and(isblank(if(A2='Raw Data'!A:A,'Raw Data'!C:C)),if(A2='Raw Data'!A:A,'Raw Data'!B:B)>0),if(A2='Raw Data'!A:A,'Raw Data'!B:B))))

Post has attachment
I am back with another issue! I have linked to a spreadsheet with the raw data that has a Date 1 and Date 2, I want the smallest Date 1 returned (that is not a 0) so long as Date 2 is blank

The formula I tried

=ArrayFormula(min(if(and(isblank(if(A2='Raw Data'!A:A,'Raw Data'!C:C)),if(A2='Raw Data'!A:A,'Raw Data'!B:B)>0),if(A2='Raw Data'!A:A,'Raw Data'!B:B))))

*SOLVED!!*

Can someone tell me why my formula isn't working. I am trying to search AP2 to see if the cell contains an item from AM, and if it does I want it to return an item that is in AN in the same row as the item in AM.

=INDEX(AN:AN,MATCH(TRUE,ISNUMBER(SEARCH(AM:AM,AP2)),0))﻿

Public Post

Can someone tell me why my formula isn't working. I am trying to search AP2 to see if the cell contains an item from AM, and if it does I want it to return an item that is in AN in the same row as the item in AM.

=INDEX(AN:AN,MATCH(TRUE,ISNUMBER(SEARCH(AM:AM,AP2)),0))