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

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

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

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

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

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

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

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

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

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

I have a report with 500 rows with 12 columns of data (2013). For each account in column A I want to know what was their last month with volume. Please see attached report

Hi Team, I get a huge data dump of monthly volumes based on local currency. At this time (since there are so many different currencies) I don't do any duodecimalization. So when I add up the different months of revenue the result is in Scientific Notation. here's an example: Monthly Amounts...

Hi everyone, I have 2 reports. Report A has a bunch of data columns (actually a lot of columns and 1000 rows). Report B is a revenue report by month January through May. Each report has the account number in common. I need to take the monthly revenue and append those columns to report A. The...

Hi All....I recently given access to a spread sheet with multiple tabs. Each tab has about 10-15 different formulas. I recently noticed that a couple of the formulas were incorrect in a few of the tabs. example: b165 has the formula =sum(b162:164), however in one of the tabs it was =sum(b162)...

Hi All, I do love this site.....I'm so thankful for all of the help that is here. That being said, I have a question. I have a workbook with 2 tabs. I've mocked them in in this report: http://speedy.sh/FuEQe/Director-Example.xlsx Tab one DATA has a lot of columns (I've scaled it back a bit) I...

Hi there, I'm have a large report and I need to append some data to it. I've attached a copy: http://speedy.sh/cTNUJ/vlookup-for-industry.xlsx In the first tab, there are 6 accounts and US National accounts have an industry code and industry code descriptor. The US District have their...

Good morning all, I originally asked this question about 6 months ago and Hui provided me with a perfect formula. The original post heading was "help with a y/n formula" I now need to tweak that formula. I have a report that lists an account number, a settlement currency, submission currency...

Hello all. It's been awhile since I've had to ask a question. I've sung your praises to everyone who has asked me about excel! Now I'm stuck. Here's where my file is:http://speedy.sh/78YDP/APPEND-CV-BY-COUNTRY.xlsx In tab1 (main file) 4 columns: Market/Region/Country/Revenu IN tab2 (revenue...

Hello all and a Happy's Fathers Day! Long ago I had received some help (from this group) on stringing across duplicate fields. I use it all the time! Now I have a similar situation. I have duplicate rows based on codes and code descriptors. I know how to do this based on the code but am not able...

Hi there folks, it's been a few weeks since I've been here. I have a report that includes (A) ACCT_NO, (B)SUBM_CODE AND (C)SETTLE CODE. IN column D I want to use a formula where if B and C match then a Y if not a N. This is what I've used in the past: IF(B5=C5,"Y","N") However the data has...

Hi All, I'm just trying to gather some information on what to do next. Can someone explain the difference between Visual Basic Applications (VBA), Visual Basic and visual basic.net. Which one is a good one to learn the basics on? Thanks in advance and a fabulous weekend to all!