## Rid #ref error in a Index Match Formula

Below is a table for inputting , I need the output as the table below and have used a formula which is producing the #ref error, please either help me correct …

Below is a table for inputting , I need the output as the table below and have used a formula which is producing the #ref error, please either help me correct …

I have multiple excel sheets in one book. I want to combine the data of all these sheets. format is like : Name Email Referee abc …

Dear Sir, I had entered the following in cell A2 “auuae”.Now I required to count the no of “u” in this cell.Please can you suggest me …

i have scores of 10 students in their 3 exams, i need to count how many students got ATLEAST 1 score greater than or equal to 50 By:

Hi! Can somebody please tell me what you think the best way to display employee sick days in excel would be.At the moment, I have a list of all 30 employees …

Hello, I hope you can help. I am trying to find one cell in a column and then find another cell in the same column and then sum what is between the …

I’mtrying to automate sending emails from Excel 2010 whenever the data in any cell in a column changes. For example: If cell c13 changes I want to …

Hi Sir, I have query that in my data base how to generate new worksheet automatically as per remarks and transfer data in that particular sheet which …

Hi, I have some data for very 3 hours of each day of year and some other data are average of day. Now I have to use the every 3 hours data and I’m …

Hi I am trying to create a chart that excludes the current months data (see table below). I have managed to do this before for daily data see example of …

how to get the difference of 2 times without entering the date wherein one time is before odd hours and another after odd hours for eg. difference between …

I have a question regarding Pivot Table modifying. I am using Excel 2013. What I want to do is to compare one product’s (which is the company’s …

Hi, I need to calculate the cost of x amount of serices which have fixed price. for example a server costs $9896 and I want to be bale to enter in a …

Hello I have a question on Excel. How to put the function Lookup in a function IF (as a “logical test” data). The formula is …

I am trying to create a attendance record that identifies when employees have met minimum requirements for hours completed. For example, new employees are …

I want to create a report for the following case study: …

Hello guys, Would you all give me a formula for command button “Loss”, automatically “C13” become “USD 5,00”.. Also …

I have values places in cells whereby the font colour is determined by conditional formatting. Is there a formular which allows me to sum the cells according …

Hello, If anyone could help me with this I would be extremely grateful. I am currently putting a few filters in place to flag debits with corresponding …

How to get that working? I need a function to apply values based on a character in a cell. For example: If there is a character P ( plus ) in …

Hi I have a column in which cells are filled in with a different colours let’s say blue and red. Is there any way that I could fill another cell based on …

I have a worksheet with numerous coroured cells and I want to know the colour index of each cell. How can I find the colour index numbers so that I can …

I am trying to come up with the formula for the following. If M5=C and N5=Y then BG5=1 If P5=C and Q5=Y then BG5=2, If S5=C and T5=Y then BG5=3. …

Need a formula transpose a value seperated by colon into the same cell EG: 192.168.1.1:192.168.1.2:192.168.1.3:192.168.1.4 I want the data …

Hi All, I am checking around 10000 records manually from a website and populating data acquired from the website in excel sheet. For Example i copy one …

Hi there, Ok have two things i want to do and have no idea how to do it. 1) Evenly distributing one column over three other columns. So, at work we have …

Kindly help me on the below formula, …

I read my water meter weekly, I need a formula to see how much water I used in a month. By: