Is there an Excel formula
| Posted By | Message |
|---|---|
|
Is there an Excel formula That that I can use to find if values in one column are not in another. |
|
Posted 4/26/07 11:14 AM
|
|
|
Long Island Weddings
Long Island's Largest Bridal Resource
| |
|
Re: Is there an Excel formula can you just sort them by the columns that A and B ar in. You can sort s it so that is sorts by the invoice that column a is in and then the column that B is then, so then all of the invoices that are in column B and not in Column A would be at the bottom.... Message edited 2007-04-26 11:22:57.877000. |
|
Posted 4/26/07 11:20 AM
|
|
|
Re: Is there an Excel formula not so much a formula, but you can do Control + F to FIND, or just go under Edit, and hit FIND, then enter the value (data) of what it is you're looking for Message edited 2007-04-26 11:21:30.750000. |
|
Posted 4/26/07 11:21 AM
|
|
|
Re: Is there an Excel formula do a vlookup - =vlookup(value, range, number of cells, "false") |
|
Posted 4/26/07 11:37 AM
|
|
|
Re: Is there an Excel formula Use a V lookup like Red suggested.... Message edited 2007-04-26 11:40:28.720000. |
|
Posted 4/26/07 11:39 AM
|
|
|
Re: Is there an Excel formula Try this: |
|
Posted 4/26/07 11:42 AM
|
|
|
Re: Is there an Excel formula Countif is actually easier. |
|
Posted 4/26/07 11:47 AM
|
|
|
Re: Is there an Excel formula Thanks Guys |
|
Posted 4/26/07 12:28 PM
|
|
Potentially Related Topics:
| Topic | Posted By | Started | Replies | Forum |
|---|---|---|---|---|
| Spinoff to powdered formula... | MrsJ | 3/23/06 | 13 | Parenting |
| Coupons for Formula | Briannasmommy | 3/23/06 | 2 | Parenting |
| Powder Formula vs. RTF? | preciouslove | 3/23/06 | 25 | Parenting |
| Similac Formula Gift in Mail | Mommyof2 | 3/19/06 | 2 | Parenting |
| formula up for grabs | momAGAIN | 3/19/06 | 0 | Parenting |
| Formula Question | Ali1 | 3/19/06 | 9 | Parenting |







