Profile cover photo
Profile photo
Brittany Wilkey
662 followers
662 followers
About
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))))

Link: https://docs.google.com/spreadsheets/d/1crBNBsYdYX2nfJvVAMslRTadeXIiTzUHQtw4hvdAtQ4/edit?usp=sharing

As you can see it is only returning 0s. Please help you wonderful people you!

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))))

Link: https://docs.google.com/spreadsheets/d/1crBNBsYdYX2nfJvVAMslRTadeXIiTzUHQtw4hvdAtQ4/edit?usp=sharing

As you can see it is only returning 0s. Please help you wonderful people you!

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))))

Link: https://docs.google.com/spreadsheets/d/1crBNBsYdYX2nfJvVAMslRTadeXIiTzUHQtw4hvdAtQ4/edit?usp=sharing

As you can see it is only returning 0s. Please help you wonderful people you!

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))))

Link: https://docs.google.com/spreadsheets/d/1crBNBsYdYX2nfJvVAMslRTadeXIiTzUHQtw4hvdAtQ4/edit?usp=sharing

As you can see it is only returning 0s. Please help you wonderful people you!

*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))

Link to Google Spreadsheet where the formula WORKS FOR SOME REASON https://docs.google.com/spreadsheets/d/1UCL71s-QraLRkh0ryEa7BqFIKOeULEQ53QyM1aNbbnw/edit?usp=sharing

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))

Link to Google Spreadsheet where the formula WORKS FOR SOME REASON https://docs.google.com/spreadsheets/d/1UCL71s-QraLRkh0ryEa7BqFIKOeULEQ53QyM1aNbbnw/edit?usp=sharing


Post has attachment
There's snow on the cardboard. Everyone can shuttup now #merrychristmasstarbucks
Photo

Post has attachment
Shrimp is love. Shrimp is life.
Photo

Dearest +Inbox by Gmail 
I need to be inside you. I need to feel your warm and inviting soul. I want to dance in the glow of your sun and dream under your watchful moon. Organize my life and be my loving wife.

Sincerely,
Needy Inviterson

Post has attachment
Total bros
Photo
Wait while more posts are being loaded