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 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'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 …
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 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 …
attached is the file with example data , column A is what i have and column B C D is what i need to get with formula.
any help is appreciated.
Please healp how transpose in yellow range values with formula. With transpose or with other formula...
have an list of numbers
but i need identifu the doublesas i type in
like the example here
I am trying to move column A’s unique values from raw sheet to temp sheet this is the code I am using however it is taking a lot of tie to process when the entries are more than 50000 is there any …
I have data in cel B7 IF IS TRUE I NEED POPULATE THE ADJACENTS CELL WITH A LIST OF VALUE
LIKE THE EXAMPLE HERE
HOW CAN I DO THAT ?
THNKS IN ADVANCED
Dear sir, i have matrix table in excel where its shows correlation between two stocks, i need to pick stocks if it has above 90% and between 8090 % and so on .
i need a database that i can build to hold all on my marketing campaigns information
i currently have a variety of excel spreadsheets that i will import into the database as well
which database…
Hello,
Hoping someone can assist in developing a macro that will clean up a spreadsheet. Please see attached where the 'Before' tab shows how the data appears raw and the 'After' tab shows how I …
I want to get a date like 23Nov2008 and get it to show the persons age this year  so not the age they are now if their birthday was in June but what they turn this year.
Hi everyone,
I have a column in an EXCEL spreadsheet made up of a date and time in the following format  m/d/time HH:MM. For example, 1/1/2017 18:24. I'd like to separate this into two cells. …
I have a basic spread sheet. I have attached a sample.
I would like to sum column c if column b has the word "Swings" in it AND the date in column a is between 112017 and 1312017
I cant …
Hi Experts,
I have a spreadsheet that contains dates in Column G. If that date in Column G is greater than 7 or = to the present date, then in Column H when clicked, you are prompted with a "Yes" …
I have a spreadsheet that has a model type in column A and could be any number of serial numbers in column B for that model. I need those broken up in separate rows and the model copied down as well …
Hi,
I would like to find a closest match by comparing two columns in Excel. I tried VLOOKUP and MATCH but they return only if it is an exact match. Is there a way to find a closest match? I am …
In the attached spreadsheet, I have 2 tabs. The first tab is what I cut and paste my inventory into. In Column "M", I want to return from a list in the second tab the value for MIN, or the minimum …
Hello  one of my users came to me with this issue. Their spreadsheet starts spacing the rows and changing the highlighting colors after row 85, and they don't know why. I can't see why either and …
I have a customer with 20 computers (Windows 10) connected to a SBS 2011 Server. They all run Office 2013 and they all have random issues with Excel locking up when they have multiple spreadsheets …
HI
Is there a way to sort a block of data automatically from one part
of the sheet to another.
I have attached a spreadsheet which was sorted manually
To be sorted on column C
Thanks
Ian
im very simply trying to sum up 4 numbers in a spreadsheet. and no matter how i do it. excel does not add them up correctly.
if you look at the picture im trying to have excel sum up …