## 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:

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.