- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
re: Excel question for you geniuses
Posted on 4/25/24 at 11:01 pm to King Crab
Posted on 4/25/24 at 11:01 pm to King Crab
Does each list have inventory numbers or some other unique identifying data?
If so, a simple countif function can be used to tell you which items in the master list have been inventoried.
=IF(COUNTIF(Inventoried!A$:A$, A2) = 0, "Not Inventoried", "Inventoried")
You would put this formula to the immediate right of you last column of data in your master inventory list. Then copy it down to every row in the master list. It will tell you which items were inventoried and which weren't.
Adjust the Cell References to point to the correct columns
If so, a simple countif function can be used to tell you which items in the master list have been inventoried.
=IF(COUNTIF(Inventoried!A$:A$, A2) = 0, "Not Inventoried", "Inventoried")
You would put this formula to the immediate right of you last column of data in your master inventory list. Then copy it down to every row in the master list. It will tell you which items were inventoried and which weren't.
Adjust the Cell References to point to the correct columns
This post was edited on 4/25/24 at 11:02 pm
Back to top
Follow TigerDroppings for LSU Football News