## INDEX / INDIRECT

I am using the INDIRECT function to get data from a file and would like to use the INDEX,MATCH function instead. This would mean the i can access the data …

I am using the INDIRECT function to get data from a file and would like to use the INDEX,MATCH function instead. This would mean the i can access the data …

i need query which can map data of each user who attened different programs(All programs are in one cell per user) to be mapped to each user attending each …

I need help with excel. I am trying to calculate number on individual product type sold per month and then enter total sold in month onto a table. I have …

Is there a formula to check which cells occur within a specific month and year? Start end Mon, 23/08/2019 Tue, 24/08/2019 Mon, 15/01/2018 Mon, …

I’m trying to create a formula that is conditional on both day and time. Specifically, if the current time is AFTER 1600 on a Friday and BEFORE …

I am currently using Microsoft Excel 2013 on a Windows 10 computer. I have this formula that I thought will give me a blank result if a range of cells are …

I have text in A1 that I am trying to locate with text in column B. the cells in B contain more text beyond what I am looking for in A. I need it to find A …

Column A- list of accounts Column B- list of managers Column C- a smaller list of accounts that should be in A I need to compare columns A and C, then …

Hi, i have 2 rows with same ID, i want to compare the columns start date or months, when teh ID matches, i want the result as those whose start date is greter/ …

how to search data in one excel cell meaning if my data shows 0202 cat 0203 dog 1017 duck 1022 horse and if i type ohr or the number that …

Hi How do i get Sheet 2, A2 to copy Sheet 1,A2 if Sheet1,G2=Won Thanks in advance. By: Craig

I want to find out the hourly rates of employees by looking up at their skills and experiences.I have a separate dataset in which all the data of the employees …

TOTAL MZN ZAR USD 200 200 200 No Date Currency Narrations Debit Credit Balance MZN Balance USD Balance ZAR 1 1-May-19 MZN Income 100 100 2 …

hello, I am trying to figure out an excel formula for the problem below. If Apple with the condition number of 23, and 23 fall between min/max range from …

Hi, I am trying to create a cell that shows whether a project is on track, late or ahead of schedule using multiple dates derived from multiple tasks within …

Hello there! I need help with the VLOOKUP formula, can anyone help out? Many thanx in advance! I can upload a file, so it will make it clearer. Emanuela …

I have multiple columns of info that I need condensed into just one column. However, I also need that one final column to mention the info only once. In other …

Hi I have 2 sets of data. I want to tally the amount of times one is greater than the other. For example …

IF I HAVE TWO SPREADSHEETS AND I WANT TO FIND WHERE: IF VALUE IN “SPREADSHEET 1” COLUMN A MATCHES A VALUE IN COLUMN A IN …

I have a spreadsheet with columns representing the months of the year. What I need is formatting to change the color of the font after the end of that …

Hi, I have the following formula: …

i have 3 shifts A shift is from=6:00-15:00 B shift is from=13:00-22:00 C shift is from=21:00-6:00 excel should automatically …

I need to retreive the value from the last non blank cell in a set of cells (not on the same row or column), so, I use this formula: …

I am struggling to create a conditional format formula that highlights the following; – Highlight any rows of the cells within Column B …

I have a list of 20 checks. I am looking for 8 that equal $1128.25. Is there a formula applied to the 20 to find which 8 give me my total? Thank you for your …

I am trying to create a formula which will find all of the students in a particular program by subject code. My formula works if there is just one …

Could someone break this formula piece by piece and explain how it works to me? it works appropriately in my file, but I am unsure how exactly it works. …

find the bonus.if sales greater than or equal to 500000,bonus is 0.5% on sales, otherwise enter zero. By: OSHADHI DE

Hi, Please I want to know the formula if the rersponse received within 12 calnder days to give check mark And if more that 12 calender days to give X as …

Hello, i know there must be a simple solution to this but cant figure it out atm. I have a table that i added to data model and then take out graphs from. The …

How do i Express the following multiple conditions in 1 formula IF A1=10 and B1=15 then C1=Apple Else C1= Orange IF A1=20 and B1=25 then C1=Tomato Else C1= …

Hi Everyone, I have two drop down one will have the values of all month that is from January to December other one is dependent dropdown will have values of …

An API returned the following result: { “Global Quote”: { “01. …

So what I’m doing is hyperlinking my summary page items with each worksheet in the workbook. I’m getting an error in my code on the last line …

I want to have the date auto fill in column G when the word “Complete” is in column F and want it to stay that date. How do i do that or can that …

I am trying to create a spreadsheet that will total the number of hours spent in work during each month and give me the monthly average based on the number of …

I am setting up a workbook for tracking some video game elements for a friend. It’s set up with a couple cover sheets that pull data from 100 …

Hey guys, I’m looking to my Google sheet has varies columns with values inserted in the rows (62 rows). I want to insert a few rows to represent what …

Hello: I am trying to create a formula that will search two columns of data. Each column is on a separate sheet within the same workbook. If …

RIght now I have a workbook that has a masterlist of data that updates another worksheet for the first quarter. We need to create a third worksheet for …