Hello,
I'm sorry for asking the solution again as the last one did not work as required, but I thank Shams for helping me understand the way it is done. :)
But the problem stays as it is.
So…
I had this question after viewing Export CSV from Excel and exclude rows based on cell value …
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 …
Hello everyone.
Please I really need help.
I have a matrix that I want to square (multiplying it by itself).
and then I'm gonna add the value of each row of this matrix, and then add the value of …
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 …
I have list of outputs. Say around 100,000 rows
They give results of a calculation.
The result is between say 1 and 100 on one axis and 0 to 50 on another , with 3 or 4 decimal places
I need to …
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
…