Recent content by Jaimee001

Hi Team, Here is the formula: IF(AND(C2<21,COUNTIFS(A$2:A$20651,A2,C$2:C$20651,">20")=0),"<21","") what I'd like is to get the data where C2 is between 11 and 21. I'm not sure how to write that. I have the formula where C2 is <11 and I thought I tweaked it by the above but it's not giving me...

Hi Team, Back in September, I posted a request looking where the daily count was less than 20 a day by account: I have a report with about 500 accounts ( column A). Column B is a date column from 1/1/2015 through 5/31/2015. Column C is their total daily count for that day. Column D is a formula...

Thank you both Naranyank991 and Eibi!!!!!! You're AWESOME!!!

Hi Team! Hope everyone is well.... I'm having issues writing a nested if formula, I've tried different types but I cant get it to work I have a report where column A is a count and Column is the formula The breaks outs are: if the count is: < 100 = 20 >100<350 = 25 (between 100-350) >350...

Hi Team, I'm not sure if you can help. I tried to mock up a report and couldn't get it not to work. I get a report with about 30 columns and 1000 rows with the cells already color formatted. To this report, I use Vlookups to append data from other data sources. Once the v-lookup is done, I do a...

Thank you Nebu!!! It worked!!!!

Greetings all! I have a report, Column A has 135 Rows Column b has 746 Rows Column A1 = ADTSEC5226.J87364 The match in column B is in row 14 The match has to be made on the first 5 bytes of the cell I had a formula that makes a match straight across original formula...

Hi Team, I've been racking my brain trying to figure out how to do this. I have a report with about 500 accounts ( column A). Column B is a date column from 1/1/2015 through 5/31/2015. Column C is their total daily count for that day. Column D is a formula to determine if the daily count is...

Thank you so much!!!!!!!!! Love it!!!!