Forum Discussion

Marco365's avatar
Marco365
Brass Contributor
Feb 03, 2020

Assign a number to the different values

Hello guys,    This is my first time here, and I am not an excel guru. I would like to use some help. I am not sure if that is the right subject for this but I attached the file. I am trying to ass...
excel
Formulas and Functions
Marco365's avatar
Marco365
Brass Contributor
Feb 04, 2020

SergeiBaklan 

 

Wow, this is amazing. I think this is exactly what I needed. Knowledge is a powerful weapon. Thank you  from the bottom of my heart Mr. Baklan. 

 

I have a few other formulas that I have been working on and I have been going the long way. It takes forever. 

I will post as much as I can, but what is your suggestion on how to go about mastering excel or formulas? How do I find out the specifics I need to learn instead of the whole excel world? 

By the way, what is the name of this formula you created or under what category is it under? Yesterday I learned about ranks,  I have been watching a few videos on it so far. 

I am going to analyze the formula you sent, I see quite a bit of formula. Ill try to practice on it. Thanks again. 

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Feb 04, 2020

Marco365 

It's hard to say which way is better. If start with basics, it's worth in Excel in File->New search "tutorial" and check them. That's about a dozen of different tutorial files from Microsoft.

 

To solve concrete task try to google for something similar, you may find practically everything and different variants of the solution. Take as a pattern and since that's usually a combination of functions, google for another samples/tutorials for better understanding of first one.

 

In above formula are used dynamic ranges, e.g. A1:INDEX(A:A,COUNTA(A:A)) instead of A1:A400; value lookup as INDEX/MATCH and more simple MAX and MATCH.

Resources