Search results

for the account 11111 there was only information January through May not July so for that account the last month would be May. The next two accounts in the report have data through July. Hopefully that helps

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

Thank you all for your responses....

Hi All, Sorry, I didn't explain it well. The data that I get is in different currencies without any decimal places. Different currencies can be 'decimalized' differently. For example, the above numbers are in Hungarian Forints which uses 2 decimal places, Japanese Yen has no decimal places and...

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

Thank you both for your quick reply. I'll check them out tomorrow at work. :)

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

Thank you both!!!! it works perfectly!!!!!

Hi SirJB7, Here is the updated link with the formula in column I: http://speedy.sh/f9FFk/Director-Example.xlsx Thank you!

Thank you Sir JB7, However, instead of appending the actual name of the director, I'm getting "false" in that column: Full Name Director Jaimee L Beebo FALSE How can I tweak the formula to get the actual name?

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

Thank you OldChippy!!! It took me a bit but I totally get it!!! THANK YOU SO MUCH!!! I've spent WAY too much time trying to figure this out!!!

Hi Jason, Here is the correct link to the sample report: http://speedy.sh/Kh25w/vlookup-for-industry.xlsx I did try a VLookup and on those accounts where there isn't a match and there is an industry code, it changed to #NA. Is there a way to 'skip' those accounts that already have an...

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

Not quite, I only get back an 'N' where there is data in each of the columns. The report may have fields that are blank. There should always be something in the settlement currency (b) but the account may not have any submission currencies if they didn't submit or just 1 currency... I know...

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

Hui, You totally ROCK!!!! Thank you so much!!!! Works perfectly!

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!

Thank you Faseeh, you are absolutely right...I don't know what I was doing wrong but the VLOOKUP formula works just fine....Thanks again!

Hello all....I have a workbook with 2 tabs. The first tab includes about 100K rows of data. Tab2 includes about 2000 rows of data with some fields being blank. Each tab has an account number. ON Tab 1 I want to do a formula that pulls the data from tab2 where there is a match on the account...

SIRJB7 Thank you so much!!!!! I had such a hard time making the formula work, so I walked away, went grocery shopping, came back looked at it again and it worked!!! Thank you again!!!