Positioning a Value in a Kardex Table

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3155156%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EPositioning%20a%20Value%20in%20a%20Kardex%20Table%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3155156%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EDear%20All%2C%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EPlease%2C%20I%20have%20a%20Kardex%20Table%20like%20this%3A%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F347357iA2CB956D6E69EF50%2Fimage-dimensions%2F661x76%3Fv%3Dv2%5C%26quot%3B%22%20width%3D%22%5C%26quot%3B661%5C%26quot%3B%22%20height%3D%22%5C%26quot%3B76%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22LDS80_1-1644593797112.png%22%20alt%3D%22%5C%26quot%3BLDS80_1-1644593797112.png%5C%26quot%3B%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Eand%20I%20want%20visualizing%20a%20Value%20(ID%20of%20Task)%20in%20the%20cells%20respect%20the%20status%20(First%20Column)%20and%20Lifetime%20(1%20to%2030).%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI%20have%20a%20table%20of%20value%20in%20another%20Excel%20Sheet%20(ID%2C%20Phase%2C%20Lifetime).%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EHow%20I%20could%20visualizing%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3155156%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
New Contributor

Dear All,

 

Please, I have a Kardex Table like this:

LDS80_1-1644593797112.png

and I want visualizing a Value (ID of Task) in the cells respect the status (First Column) and Lifetime (1 to 30).

I have a table of value in another Excel Sheet (ID, Phase, Lifetime).

How I could visualizing?

3 Replies
a sample sheet might help us to understand. On another sheet you have the ID, Phase, and Lifetime but what do those mean in terms on what you need? In the picture you included what are the green, yellow and Red areas? i search Kardex Table and didn't find any quick answers either.

Hi @mtarler,

 

Yes, exactly. In the same Excel, I have a sheet as:

 

ID Numeber            Detailed Status              Life Time (Days)

AAA                         Initial                              3

BBB                          Initial                              1

CCC                         On Going                        15

.....

 

I would like to positioning the value AAA, BBB, CCC.... in the Matrix Y=Detailed Status and X=Time (Days)

 

Thank you so much,

 

@LDS80 

I'm sorry I'm still really unclear what you want and if you are looking for a technical answer (i.e. how to get a certain formula to work) vs. a more general suggestion (i.e. suggestion on how to set up the sheet for you presentation).
What I think you are trying to do is create some visual output based on various 'Detailed Status' conditions where each ID may have different 'Life Time' values. So in the latest response you show 'Initial' has both AAA and BBB with Life Times of 3 and 1 respectively. So going back to the 1st post are those 6 items listed in column A the 'Detailed Status'? Are the Red, Yellow and Green something specific or just an idea of how you want something over there to show corresponding 'Life Time'? For example in the reply you have IDs like AAA, BBB, CCC, ... so are IDs unique and not repeat? or do you have AAA listed again with a different Detailed Status and Life Time? Does the green in the 1st represent all the AAA listed or a mix of IDs?