I need to inventory one off parts and multiples of the same item. Currently - there is no way to scan the bar codes. I’d like to be able to type in a part/serial number and have the spreadsheet either add that item to the list (if new in spreadsheet) or add it to a running tally (if existing in spreadsheet). Let me know if this makes sense. Also, please explain it to me like I’m a 10yo. Thanks

like
Posting as :
works at
You are currently posting as works at

Not sure what your ultimate goal is here. But if you are looking to create a list of all unique parts then you could just use the unique function. Eg

=unique(A:A)

Would make a list that is 1,1,1,2,1,1,2 (in a column) into

1,2 (in a column)

Then, you can use a countif function to tell you how many times they appear in your list

like

If the original data is in column A and the unique list is in column B, in column C you’d do a countif function where the range is all of the data in column A (make sure to lock the cells), and the criteria is the single cell to the left in column B. Then drag that formula down and it should get the count of each unique item in the list

Use a Microsoft list, just add a record each time you have a new part. Use Power Query and excel to manipulate the list data and show you the necessary totals.

like

Related Posts

I'm starting to get worried about layoffs! What are good fields to carry or translate these skills into? Has anyone done so? Would appreciate any advice!

like

Any advice for a freelancer on the best software to use to keep track of finances?

like
like

Futures are crashing....with the fed slashing rates, I thought that would have the opposite outcome? I don’t fully understand the impact of that but I thought the market would be positive to that.

like

Does anyone here have an experience of filing an EB1A or NIW petition. A law firm suggested me to first do a NIW petition and then follow it up with EB1A. Is it a good strategy to do it this way because NIW is more certain and gets a place in the line? Am I missing something? Should I instead file an EB1A directly?

Also, any good law firm suggestions for EB1A petitions based academic credentials? Thanks for the help

like

What benefits are included in EYs frequent traveler program? How many miles or stays are required?

like

Stressed about career growth and pay. I have wasted a few years at Slalom hoping things would get better but they have not. Now I’m a few years into my career with lower pay than the market and

like
like

Is DUI frowned upon for a client background check?

likefunny

FAANG ranking: Google, Netflix, Facebook, Apple, Amazon. Is this correct?

like

Anyone working in appdynamics??

like

At what point in your careers did you know you wanted to gun for PPMD? Any point wherein you doubted yourself?

like

Can I give notice by email? Or is it truly preferred to call the partners directly? What if they don’t pick up?

like

I keep making stupid minor mistakes at work lately presumely cause I’ve been so burnt out, and my senior is constantly mad at me, which made me want to avoid the dirty work even more… I really should care but is it bad that I don’t really care anymore

like

About to finish my first year. I’m a specialist. Only going to hit 65% of my hours (took a 4 week vacation cause of wedding/hm).

I never say no to work and i have fantastic reviews, and the head of my practice (with whom I work a lot for) has great things to say about me.

I’ve been fully utilized starting ~June, but first few months were slow. Am i fine?!

like

Does anyone getting similar mail daily :Know Your IBM January'22 - Register Now ?

What will be in hand salary for this salary structure?

Post Photo
like

Hi! I'm technically an AD but have found myself working in so many production roles as my work and really digging it all. I would love to talk to someone about all this production. Anyone down to chat about the production life?

like

Happy new year everyone👍🏼

like

Additional Posts in Excel Genius

How long did it take you to become good at excel? Like fast?

like

Hello. Quick question about formatting. I have an excel sheet with bunch of negative numbers, but some are percentage values and some are dollar values. Is there a way to make all of them have a parenthesis for being negative while keeping them still percentage and dollar value separately or do I have to target them separately?

like

Anyone know what these badges are?

Post Photo
likefunny

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

like

Does 2-finger touchpad scroll not work on Excel sheets anymore? I used to be able to swipe quickly on my laptop's touchpad to navigate sheets but now it doesn't work. Based on the handful of posts I've read online about it, the problem seems unresolved. Has anyone dealt with the same issue and fixed it?

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

like

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

Any book recommendations on excel modeling for real world business applications?

like

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

like

Recently made a job switch and have been using a lot more excel. Any free resources to help build a solid foundation / fee based courses to help improve my skills?

like

Our Data is only showing when something has changed, is there any way to make excel fill in the values?

Post Photo
like

Would anyone be willing to teach me vlookup?

like

What is the best FP&A tool, Anaplan, Jirav, Planful, Vena? Any other recommendation?

like

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

helpful

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal