Home

excel formula

%3CLINGO-SUB%20id%3D%22lingo-sub-654143%22%20slang%3D%22en-US%22%3Eexcel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-654143%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20anyone%20help%20me%2C%20whats%20the%20formula%20i%20need%20to%20use%20base%20on%20the%20attach%20file.%20when%20i%20need%20to%20key%20in%20the%20number%20at%20%22number%22%20column%2C%20the%20result%20column%20will%20automatically%20generate%20based%20on%20table%201%20and%20sorting.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-654143%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-654218%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-654218%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F349777%22%20target%3D%22_blank%22%3E%40antan78%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhy%20would%207659%20convert%20to%20efkn%20and%20not%20to%20edgn%20or%20elcn%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-654780%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-654780%22%20slang%3D%22en-US%22%3Ehi%2C%20ya%2C%20it%20follow%20the%20number%20next%20to%20each%20other%20only%3C%2FLINGO-BODY%3E
Highlighted
antan78
New Contributor

Can anyone help me, whats the formula i need to use base on the attach file. when i need to key in the number at "number" column, the result column will automatically generate based on table 1 and sorting.

 

 

2 Replies

@antan78 

Why would 7659 convert to efkn and not to edgn or elcn?

 

Highlighted
hi, ya, it follow the number next to each other only
Related Conversations
Ribbon or right clicking will not go further out
51218 in Excel on
0 Replies
How to automate a timesheet template?
fishfish31 in Excel on
1 Replies
Excel Worksheets and templates
Christine_R in Excel on
6 Replies
Web links no longer works after data refresh
DataQue in Excel on
0 Replies
Percentage of attendance
linrojy in Excel on
7 Replies
Grouped data visibility in formula builder
Bram_Elfrink in Excel on
1 Replies