if & countif

Hi all wonderful Legends! I need some help with a form I'm trying to create. The basics are below. If the time is between 06:00 and 14:00 a box on the end needs to read DAY, or if between 14:00 and 22:00 ARVO, and 22:00 to 06:00 NIGHT. Then, if the Completed column shows no, i want another box...

I have ~50,000 usernames in Column A on Sheet1. Many of those usernames repeat. On Sheet2, I have the same usernames in Column A, followed by their employee IDs in Column B. But on Sheet2, there are no repeats. I want to copy over the IDs from Sheet2 into the corresponding place in Sheet1...

I have a column that totals the amounts of 31 other columns based on value in those cells. It works great, but there are so many rows of data that looking at a bunch of 0s for all the cells that have no data to return is eye boggling. I'd like to edit the formula to include the "IF" function to...

Hiya, I have a workbook with two worksheets in. Worksheet one has a list of telephone numbers starting in column A2 -> A143 and in D2 -> D143 are their respective owners. The second worksheet has a list of telephone numbers with charges associated with them. I want the second worksheet to...

Hi all, I am trying to compare a range against a single value to see if it exists and return a single Boolean T/F result. The formula is: =IF(COUNTIF(RANGE,CRITERIA)>0, "TRUE", "FALSE") The problem I'm having is the way I supply the RANGE to COUNTIF will be fine if I explicitly highlight...

Excel formula for multiple matches. Kindly help to find a formula in G3 and G4. I have data in column B and C, I wanted to match it with column E and F. However vlookup does not work as there are multiple matches. I wanted a result of True/False if B and C contains the values in E and F...

Hello Everyone, I was hoping anyone could help me with a formula here. There is a big table with a lot of data that I am working and I would like to count the value of the cells that have a specific text on another column on the same row. I did an example table to explain it. picture attached...

So i have 3 sets of columns with data. How can i write on the right side of excel a formula that would do this IF there is data on Column T, then select that data, if the data is 0 or blank then use column AD, if that column is 0 or blank , then use column AG, if that is 0 or blank just have N/A

So i have 3 sets of columns with data. How can i write on the right side of excel a formula that would do this IF there is data on Column T, then select that data, if the data is 0 or blank then use column AD, if that column is 0 or blank , then use column AG, if that is 0 or blank just have N/A

Hi I am trying to figure out a formula that would give me the average tenure per year of the Active employees for that year. I have a list of the employees with start and end dates and their Departments, and their tenure for each year they worked. Here are the two lists: What I need is to get...

I am looking to find out if there is a way to use excel formula to work out the cumulative number of working days a employee has been absent for when they work shift patterns So if the shift patterns are 4 on 4off, 2 days week one and 5 days week day two and the last shift pattern we have is 2...

I have data in col A (item) I need to know if it is repeat or new. the thing is, all item starts with 302 are new (N) item number, but if this item is repeating(starts with 302), I have to tag it as Repeat (R). i have the formula to find if it is repeating. =IF(COUNTIF($A$1:A1,A1)=1,"N","R")...

I was trying to find if result of concatenation is duplicate or not but the formula is not working. Below is the formula that I create. pls help in rectifying the error...