![]() |
|
|
|
#1
|
|||
|
|||
|
See the attached. |
|
#2
|
|||
|
|||
|
Thank you Xor,
I tried implementing it into my spreadsheets however it caused problems, I may have messed up the equation while doing it ![]() Also on your equation, it does not eliminate the second Apple but created a duplicate that was located in CA. Your output was ApplesCA - 8 ApplesNY - 3 BananasCA - 4 ApplesCA - 8 PearsCA - 2 |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Excel Spreadsheet
|
r00190019 | Excel | 4 | 04-06-2017 11:39 PM |
| Spreadsheet keeps crashing | SavGDK | Excel | 8 | 06-28-2016 08:27 AM |
| Spreadsheet Lock | medavidcook | Excel | 1 | 03-06-2014 09:33 AM |
First spreadsheet row is now numbered 2
|
Colonel Biggs | Excel | 5 | 02-02-2014 12:49 PM |
Spreadsheet Help
|
furface00 | Excel | 1 | 12-14-2012 08:30 AM |