Search results

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

Greetings all, I have an excel report with 2 tabs. Tab1 is the main tab with the account number and such. Tab2 is the volume tab that has 4 years of revenue per account number I want to append the revenues for years 2014 and 2015 to tab A I can make the match on the account number but i'm not...

thank you thank you thank you!!!!!

Hi All, I thought this would be easy but I'm not able to find anything. I have a report where 2 of the columns differ by just the first byte (?) I00063 000063 Is there a formula that I could use to make a match on the bytes after the first one? I've attahced an example report. Hopefullly...

You ROCK!!! Thank you so much, I love this site becuase I learn so much.... Thank you again!

Hi All, It's been a while, but now I have a question on how to add a formula to a pivot table. Here's the formula: LOOKUP(2,1/(B5:AD5 <>""),$B$4:$AD$4) (thanks to CHandoo.org). The pivot is broken out by account number in the rows and month/year in the columns and I need to add a formula to get...

Thank you so much Luke, it works!!!!! YOU ARE AWESOME :p

Thank you Luke, I'm almost there! To make it work I had to make a small change to the formula. in the section: SMALL(IF(('tab2'!$A$2:$A$6=$A3)I changed to $A$2:$A$6=$A2. That works. I also uploaded a revised report with the formula included. ROW 2 should be blank as the number is the same in...

Hi All! I've attached an example work sheet. There are 2 tabs and in column b in each tab there is a number. I need to append the number from tab2 to to tab1 IF it doesn't match the number in tab1. I thought I could use a VLoookup up but not sure how to say 'if not equal to' Then (to make it...

THANK YOU THANK YOU THANK YOU ALL!!!!! I totally forgot about the COUNTIF formula... Can't thank you enough Jaimee :):p:DD

Hi All, I have a report with 500 rows and 12 columns (2013 by month). For each row there is a number in each cell. I need to determine what rows have a full year where each month the number is less than or equal to 600. I thought I could do it by formatting the cell color but then I would need...