“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

I am trying to use Index and Match to return the first date something was billed. Conversely, eventually I need to find the same for the last date. Right now, I am using a simple index match based on the row number, but if the activity changes, I need to validate the activity on Sheet 1 with the description on Sheet 2. There needs to be some logic in the formula to match the description to ensure it is looking up the correct row. Thus the logic would be, lookup/match the description in column A, then lookup and return the corresponding date for the first column within the corresponding row with a dollar value in it.

Solved by M. A. in 29 mins

I need to create a spreadsheet where I need to locate different diameters (In Column) with different holes (In row). I need to create a formula where i type in the Diameter number it should lock that column and when i enter the hole size it should correspond with that column.

Solved by T. W. in 20 mins

I'm have two columns with different values - one column has country names, another column has Y (or is blank). I want to find a formula to count the specific name if there if there is a Y in the same row as a country name.

Solved by B. J. in 19 mins

I'm having a problem coming up with a function that will insert the value of a cell based on whether or not the min excel value in the row belongs to the column.

Solved by Z. Y. in 27 mins

IF i consider A,B, C as my excel column, i am trying to find the cumulative sum in my C column (for example A1+B1 = C1 in first row and then in second row i need A1+A2+B2 =C2) simillarly A1+A2+A3+B3 =C3. how can i do that using excel formula?

Solved by E. Q. in 25 mins

HR Metrics: Excel Activity 7
DUE:
This activity is due by June 4th at 11:59pm.
Issue:
Our employee database has been partially corrupted and we need to fix the raw data and provide our VP with answers to a few of her questions. As seen in the screen shot below, all the calculations between Columns K to R have been erased along with employee data below row 10.
Requirements:
The file has 6 tabs that you will need to use.
First you need to complete the Raw Data tab with all the necessary calculations. For some of the columns you will need to link data contained in the Reference Tables tab. This prep work is required to answer the questions in the final tab, “Questions & Answers”.
Use first 10 rows of the Raw Data tab to work out your formulas and double check to make sure you are doing them correctly (try replacing them to see if you get the same results that are already there). Once you are confident they are correct, copy the formulas down to complete this tab.
Then use the pivot tables to answer each question found in the Questions & Answers tab. Make sure you use the Q.1 Pivot tab to complete and show your work to answer Question 1 in the Questions & Answers tab. Use the Q.2 Pivot for Question 2 and Q.3 Pivot for Question 3.
Once done, save the completed file and upload it to the Assignment folder named, “Excel Activity 7”.
Marks: Completing the Raw Data tab=1 mark; Showing work in all 3 Pivot tabs=3 marks; Answered Questions tab=1 mark (0.25 marks each).
Key Concepts:
You will need to incorporate the following functions: =VLOOKUP(), =INDEX(), =MATCH()
You will also need to group data in the Pivot Table and remember how to calculate averages.

Solved by X. D. in 15 mins

I have a table with rows 1 to 1,000 and columns 1 to 1,000 (total active cells 1,000,000)
Each cell is calculated using a complicated algorithm using other variables and both the corresponding row value and corresponding column value, to produce a unique value for each cell. How do I calculate how many of the cells are above a variable value? The result should display, for example, "165,234 cells greater than $2,000", or, "504,719 cells equal to or greater than $1,250".

Solved by E. D. in 17 mins

I would like to make values in a column equal values in a row

Solved by D. B. in 14 mins

Hello
I'm making a fretboard calculator that shows the notes as fractions.
Column B is the open string tunings expressed as fractions.
I have a 3/2 (cells G14 and G15) being added to each of the open strings
Column G (fret1) shows the resulting fractions at that fret.
I simply want to copy columns C-G over to column H so I can have a fret 2
how do I copy Columns C-G so that the formulas stay intact and always reference the open string fractions (column B) I think this is called absolute values?
Than I want to copy it over again so I have frets 1-40.
Than I want to Copy that and create a duplicate version below it on row 18 for comparisons.
Any help is greatly appreciated

Solved by Z. D. in 11 mins

I am trying to copy a formula from a row to the rows below. the percentage in the formula should go up by 1 from one row to the row below. How to write the formula?

Solved by M. J. in 27 mins