present

Hi Excel Masters, I have a perplexing problem that I could use your help with. I have four columns of numerical data in varying lengths on a single worksheet. The unique thing about this data is that no value is identical across all four columns. For example, column A has a value of 200 - and...

<tbody> A B C D Day Time In Time Out Remarks Formula Friday 7:50:01 14:30:35 Present =IF(A3="Saturday",(IF(B3>=TIME(9,0,59),"Late Coming","Present")),(IF(B3>=TIME(7,50,59),"Late Coming","Present"))) Saturday 9:02:01 14:00:45 Late Coming <tbody>...

Hello, I need help on how to to count a specific value on a range after a lookup. Basically, I want to count the number of values with a condition which is date (Weekend date). Is there a way to lookup the range instead of manually inputting every time I need to count a specific value in range...

I think its easier to just show you! <tbody> Company Sector LMArchitect Architect PJKArchitects Architect PLPlumber Plumber </tbody> I have a list of companies in column one. I want to include the sector in column two. However they are a mix of letters and types. Is it possible to use...

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...

Hello I have tried searching on the issue, sorry if there is an easy answer! However, my problem is that I have a semi large data sheet with approx. 20 coloumns and 3500 rows My task is then to count the characters in each cell, for each coloumn and list up character lenghts of each cell from...