tagged

Hi, I tried enough but stuck with this problem. request someone to help:( I have list of 10000 Order Ids in column A, & Customer Name in column B. Order Ids are duplicated, some orders will be 20, some order ids will be 50 etc. In Column C i want to give this data. 5% of order Ids Vs total...

Hi i am working on an excel query were i want to identify certain cell colour b and on the basis of that want next cell to be tagged as following: If cell is yellow then next cell should be tagged as formulated if cell is red then it should be tagged as average. thanks in advance.

Hi all I have a list of names in a column A and a list of categories Cols B-F Each person can be tagged to several categories with the value of either 0 1 2 3 or 4 I am after a way to create a separate summary sheet that will tell me the person’s name in one cell (which I can do with...

I have an Excel question, in the example below I have a very long list of dates times where I added a column to calculate gaps, and tagged rows where the gap were less than 15 minutes to try to determine a possible consecutive activity. Do you have any idea how to get the groups of tagged rows...

Hi All, the below is my formula and it works =If(and(O84="Unavailable (Tagged Out)",E84=""),"Unavailable",If(and(O84="Unavailable (Tagged Out)",E84="Completed (Repairs completed, <b>Available</b> and safe to use)"),"Available", If(and(O84="Unavailable (Tagged Out)",E84="In-Progress...

Hi, A little help for my formula below please? I wanted to show in column E that if the actual login is equal to the person's schedule, she will be tagged as "P" or present and if he's tardy from his schedule but didnt exceed more than 5mins late, then he will still be tagged as Present. I...