Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Verify if Acct # that is on wksheet is on another
I have a main worksheet with all available accounts. I want to see if there
are accounts on my other worksheets that are already on my main worksheet. Thanks, -- Donna |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Verify if Acct # that is on wksheet is on another
Easy enough using EditFind and set Look in: option to "Workbook"
But what do want to do if you find a duplicate? Gord Dibben MS Excel MVP On Thu, 15 Jan 2009 13:40:01 -0800, Donna wrote: I have a main worksheet with all available accounts. I want to see if there are accounts on my other worksheets that are already on my main worksheet. Thanks, |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Verify if Acct # that is on wksheet is on another
i guess. I have one main worksheet with all the accounts on it. I want to
see if an account on another worksheet is listed on the main worksheet. -- Donna "Gord Dibben" wrote: Easy enough using EditFind and set Look in: option to "Workbook" But what do want to do if you find a duplicate? Gord Dibben MS Excel MVP On Thu, 15 Jan 2009 13:40:01 -0800, Donna wrote: I have a main worksheet with all available accounts. I want to see if there are accounts on my other worksheets that are already on my main worksheet. Thanks, |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Verify if Acct # that is on wksheet is on another
"Donna" wrote:
.. I have one main worksheet with all the accounts on it. I want to see if an account on another worksheet is listed on the main worksheet. Assume key data, eg account IDs are listed in Sheet1's col A (your master) In the other sheet, assume the account IDs to be checked against the master are running in A2 down You could place this in B2: =IF(COUNTIF(Sheet1!A:A,A2),"Yes","") Copy down to return required results Pl mark ALL responses which help by pressing the YES buttons (like the one below) -- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Verify if Acct # that is on wksheet is on another
Hi Donna,
A quick way is to use the vlookup (vertical) formula, which looks for an match and returns whatever you want returned in your array. If not found the result would be #N/A, which would be any that are not on your main worksheet. There is also a hlookup (horzontal). If using the function wizard, it will describe exact what is needed, step by step. Excel help also will explain well. Hope this helps, once you are comfortable with lookups, you will find you use them very frequently. "Donna" wrote: I have a main worksheet with all available accounts. I want to see if there are accounts on my other worksheets that are already on my main worksheet. Thanks, -- Donna |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
import stock prices from discount broker acct | Excel Worksheet Functions | |||
how do I set up a spreadsheet and auto update from another wksheet | Excel Worksheet Functions | |||
How can I convert Excel .csv to .qif for download into bank acct? | Excel Worksheet Functions | |||
How do i link an entire source wksheet to a dest' wksheet | Excel Worksheet Functions | |||
Pulling information from another wksheet by date | Excel Discussion (Misc queries) |