I am looking for a formula to put the "status" of a project from the worksheet Matrix (2) in the right row of the reference table (1). I tried index match but could not solve the problem.
In the wsâ€¦
I have this formula in Q13:
=IF(OR($Q19="2: 1/4";"2: halv");0.225*1*0.25;0.225*1*0.5)
Then in Q19 I have a dropdown list with these values:

2: 1/4
2: halv
Note that the first â€¦
I have a worksheet with multiple sheets within. In column A (RUP) of sheet 1 I have check boxes (which aren't working). I need all of the data in each row from the main sheet to copy to the RUP sheet â€¦
I have a daily routine that involves downloading a list that I need the cell contents of several columns to be populated into a comment for the cell in column A for the same row  but also have the â€¦
Hello,
I'm new in excel and vlookup, so consider me a near zero knowledge in vlookup and conditional formatting.
query:
Advisor: Total CSAT%
Abhishek Deb 77.92%
AJAY KUMAR â€¦
HAVE A COLUMN WITH DATA NEED TO BE REORGANIZED
THIS WAY
I'm trying to sum the number of dates with in a range for a given document type using SUMPRODUCT in the attached example spreadsheet.
I can get the formula to return the correct value for a single â€¦
i need a formula to count the number of capital letters in an excel formula
Hi Experts,
I have a somewhat complicated issue that I think might be resolved with the use of a combination of an Index Match Array formula but can't see how to do it. That said, there may be â€¦
I need a vba loop to remove all instances of these shapes.
There are multiple, and for some reason and this code only removes one, not all.
I need to loop through until there are no more.
â€¦
Loan amount = $61,000
Annual interest rate = 3.5%
Period of load = 30 years
Monthly payment = $0.00
Balloon payment amount at the end of 30 years = ?
I am trying to develop a schedule in Excel â€¦
I have a list of phone service providers with their area code beginnings such as ( 307650 : Provide: SPRINT SPECTRUM) and I want to find whether which one (who) is the phone carrier using 10 digit â€¦
I am trying to change shapes using VBA, but getting error on the With Selection.Shapes("ARROW_US_EMEA_DC").
Can anyone help?
(CODE)
we have a spread sheet that stores unallocated IT stock (e.g laptops in stock, yet to be assigned to an end user). When an order is received the spread sheet is updated with the end user who the â€¦
I NEED TRANFER A BIG DATA COLUMN
LIKE THIS SAMPLE ANY HELP ??
Hello I am trying to keep in place or make it possible for my Excel chart to remain linked in my PowerPoint file. I have tested this with a download of a zip file and when I open the PowerPoint there â€¦
Attached is a sample Excel file. The Pivot WorkSheet has two Pivot Tables. That obtains the data from the Data Worksheet. The Pivot Table on the Top has a Sum of Product 1 and Product 2 as well as â€¦
I have a column that contains data formatted like this "nnnnn, text". There is one sheet per month. I wish to "fill" (color?) any cell that has identical data in any other sheet with a light â€¦
Hi, I've been testing with users and recording their response times during the period of an hour and a little bit after that hour. Now that i have the exact response times, I'm trying to figure out â€¦
I need to add a button that, if clicked, will
copy C2:G2 to the next empty line line.
then copies MOVES VIA, COUNTRY & CONSIGNEE into the new line.
I have been given a text file which I need to place the data into a MySQL table, Excel or Even Access.
The text file contains:
A  win
B  howdy
C  go home
D  have lunch
A  happy
B  sad
â€¦
I have a daily routine that involves downloading a list that I need the cell contents of column H (BRKR) and column I (CUSIP) to be populated into a comment for the cell in column A for the same row. â€¦
We are trying to build and excel spreadsheet for our sales people on their commission they earn and are have difficulties putting in the correct formulas. Here is what we are trying to accomplish. â€¦
Attached is a Workbook where Column B (Table1 Worksheet) is filtered and the results for Col A can be recorded in P1, Q1, R1, etc. Currently, it's a bit of a work around to display the values of Col â€¦
Programming in PowerPoint 2010 VBA, an automatic bio slide maker. The user selects up to 6 bios from a picklist, then the macro inserts photos and text elements. Name, title, and bio text for each â€¦