Need to generate new code and new no. from given L column
I have attached excel file and also with sample output i need formula for 2 J & K columns, please suggest me.
Need to generate new code and new no. from given L column
I have attached excel file and also with sample output i need formula for 2 J & K columns, please suggest me.
Last edited by maddyrafi1987; 01-05-2024 at 03:33 AM.
Administrative Note:
We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do with this formula.
Please take a moment to consider amending your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).
Please see Forum Guideline #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I've looked at the workbook. You need to explain the logic. Once again you have offered the absolute minimum in terms of what you want and expect your halpers to work it out.
This is not acceptable, especially as you have been told about it before. Explain in DETAIL what you want to happen and the logic you are applying.
Mam, If Federationname column it shows 001 code and it having 3 (001) rows in different fed.name means then fed.code column should be 1,2,3. in fed no. & in fed. Code F1-001, F2-002, F3-003, for next new fed.name it should come like in fed. Code is 4 and fed. No is F4-028(that federation name code) and its repeated to next any rows means it will remain the same otherwise it should come other other rows newly
Last edited by maddyrafi1987; 01-05-2024 at 03:49 AM.
Can you please annotate the workbook with an explanation of each of the examples given?
FederationNo FederationCode FederationName
3 F3-001 001-Singampunari vattara vayalaga kootamaippu
1 F1-001 001-Kottampatti vattara vayalaga kootamaippu
2 F2-001 001-Nattarampalli uzhavar mamandram
4 F4-022 022-Bodi vattara kalanjiam
4 F4-022 022-Bodi vattara kalanjiam
5 F5-002 002-Mudhukulathur vattara vayalaga koottamaippu
If Fed. name is 001-Singampunari vattara vayalaga kootamaippu then fed. no. should be 1 and fed. code is F1-001 suppose it have 3 federation names starts with code 001 means then it should 2, F2-001 & 3, F3-001 etc.
if another for new fede. is new means then it should be come like 4-F4-___ here what is the federation name code it should be display.. it should be go like this
OK - you choose to ignore my request. Therefore I choose not to help. Your choice.
I am having 3 columns fed. no, fed. code, fed. name, here i want to generate fed. no. & fed code to all fed. name given, here i want to generate like for first fed. is 001-Singampunari means then fed. no. is 1 and fed. code is F1-001,
For second line fed. name is 022-Bodi vattara kalanjiam then fed. no is 2 and fed. code is F2-022
For Third line fed. name is 022-Bodi vattara kalanjiam then fed. no is 2 and fed. code is F2-022
For fourth line fed. name is 002-Mudhukulathur vattara then fed no is 3 and fed code is F3-002
For fifth line fed. name is 003-Kadaladi vattara then fed. no is 4 and fed code is F4-003
For sixth line fed. name is 010-Sedapatti vattara then fed no is 5 and fed code is F5-010
For seventh line fed. name is 003-Kadaladi vattara then fed. no is 4 and fed code is F4-003
Hope its clear
I asked you to annotate the workbook. If you do that, I'll have another look. If you ignore the request, I won't.
Mam, I have updated my earlier post, please have a look
I asked you to update the workbook with annotations - this is NOT what you have done.
Good luck! I have run out of time and patience, I am afraid.
I have given inputs in sheet2 page but i need answer in sheet 1 J&K column as like sheet 2 mentioned
In the file, on Sheet2, it states: "If 001 code having 3 rows means then fed.code column should be 1,2,3. in fed no. & in fed. Code F1-001, F2-002, F3-003..."
However, in cell D2 displays 3 and cell E2 displays F3-001 instead of 1 and F1-001 respectively, which is what the above statement indicates.
Please explain.
I feel that once we understand how the Federation number column should be populated the Federation code column could be populated using: ="F"&D2&"-"&LEFT(F2,3)
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks