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

Hi Chihiro, I like your formula however I can't get it to work. I've attached a word document with the formula you provided and mine. I just changed one field. When I run it, the results are blank. I'm also oaky with having a "0" instead of blank but not sure how to change the formula to reflect...

Hi Team, I've looked through some of the responses here and am not able to find an answer. I'm also just learning VB so I'm not all that well versed. I have a report which I have to append the email address to. However, some accounts have 1, some don't have any and some have multiple email...

Many many thanks Chihiro! It works!!!!!!!

Hello team! I have a rather large excel report that is color coded. I did a vlookup to append data to that report, however, I'm not able to figure out how to append/format the cell color. The attached example report has 4 different colors but the actual report has 8 and it has to be based on the...

Hi there, I have an excel questions that I'm really racking my brains out over. I have this report and I can filter it down to about 600 rows. the issue that some of the accounts use more than 1 product. I need to get a count of accounts and their products. I used conditional formatting but that...

Thank you both Tomas and Eibi, both are excellent responses....I need to look at this a bit more and determine which is the best for me. Thank you again! :)