We'd like to remind Forumites to please avoid political debate on the Forum... Read More »
We're aware that some users are experiencing technical issues which the team are working to resolve. See the Community Noticeboard for more info. Thank you for your patience.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
Excel Function - Is this Possible?
Options

Cotta
Posts: 3,667 Forumite
in Techie Stuff
Hi All,
I have a list of attributes within column B, namely "Man Utd," "Chelsea" and "Liverpool". For each of these values there are several subsets.
However what I am seeking to know is this, within this primary spreadsheet can I put into column A via a formula the values 1, 2, 3, 4 etc for each of the attributes based on their name? So "Chelsea" would have 1, 2, 3, and 4 etc and "Liverpool would have 1, 2, 3 and 4 etc?
Thanks in advance.
I have a list of attributes within column B, namely "Man Utd," "Chelsea" and "Liverpool". For each of these values there are several subsets.
However what I am seeking to know is this, within this primary spreadsheet can I put into column A via a formula the values 1, 2, 3, 4 etc for each of the attributes based on their name? So "Chelsea" would have 1, 2, 3, and 4 etc and "Liverpool would have 1, 2, 3 and 4 etc?
Thanks in advance.
0
Comments
-
You may be best with your repeated excel issues looking at a specialised forum .
http://www.excelforum.com/ for example.
Or as iv said before - Get some training. Make your employer pay0 -
This is Excel so the answer is most likely yes!
However I am not sure I fully understand your aim. Perhaps fill in a sheet manually to give an example and post it on here?
The best I can guess is that you wish col A to contain in rows "Liverpool 1", "Liverpool 2", etc but have no idea where your subsets are located or how they are arranged with respect to col B!
Explain more to get some help, please.0 -
Yes, not enough information in the question to answer properly.
In general - write out the means of evaluating the contents of column B to arrive at the value in column A, in simple steps either verbally or mathematically. Then translate each of those steps into the Excel equivalent.0 -
Can only agree with you again!
People do not realise how powerful Excel is, being therefore more says than one to skin a cat and posters need to fully explain in language that can be understood in Excel terms. Not always easy when you have limited experience.
....and a picture tells a thousand words, it's a spreadsheet of two halves, when the final whistle is.......oooops I digress :rotfl:0 -
When I was using Excel at work to do some interesting stuff I bought myself a decent advanced Excel book.
However, I found one of the best resources was YouTube, there seem to be examples of almost everything on there.One by one the penguins are slowly stealing my sanity.0 -
If you want to get something along the following lines:-
1 Chelsea
2 Chelsea
3 Chelsea
4 Chelsea
1 Liverpool
....
etc, it's quite straightforward.
There are several ways to go about this depending on if your numbers are finite (i.e. 1-4 only) or your teams are finite (i.e. the list you've provided).
If the teams are finite (i.e. the list of teams you've supplied are all that are needed) then you can do the following:-
Enter your teams in groups of 4 in column B starting at B2.
In A2 enter the number 1
In A3 enter the following formula:=
=if(b3=b2,a2+1,1)
and drag down.
If the numbers are finite (i.e. 1-4) but the teams aren't, then it gets a little more complicated.:wall: Flagellation, necrophilia and bestiality - Am I flogging a dead horse? :wall:
Any posts are my opinion and only that. Please read at your own risk.0
This discussion has been closed.
Confirm your email address to Create Threads and Reply

Categories
- All Categories
- 350.9K Banking & Borrowing
- 253.1K Reduce Debt & Boost Income
- 453.5K Spending & Discounts
- 243.9K Work, Benefits & Business
- 598.7K Mortgages, Homes & Bills
- 176.9K Life & Family
- 257.1K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.1K Discuss & Feedback
- 37.6K Read-Only Boards