Hi Please see attached file
I am having trouble getting index match formula correct when i'm trying to reference dates and also when looking up values not found in source table
please advise correct formula and what ent wrong in my approach
Hi, I have attached file. I'm trying to look up values from "Sourcr tab" referencing to columns A and B ad the result to be produced in "result tab"
What makes it complicated is there are lot of duplication in column A
Kindly assist with formula
I am basic learner in charting. I have a file which involves multiple (more than 2) variables I would like to compare using charts
Could you kindly suggest the best possible way to do this ? Thanks
Hi Dear Friends
I have the below items on which i need to do a lookup to get corresponsing values from the lookup data
Look UP data is
I am currently using a sumproduct formula
When used in a file having massive data, the calculation is slowing down. Is there any way i can replace this with , say for example, INDEX MATCH formula which can speed up...
HI , I need help in building a formula to calculate Electrcity charges
Example- Electrcity usage is 31,180 kilo watts
Pricing would be-
1,1kilowatt to 2500 kilo watts would be charge $0.23 per kilo watt
2,Remaining kilo watts would be charges $0.32 per kilo watt
3, If no usage, price is 0...
If you could please attached spreadsheet and help advise a Vlookup formula. This involves breaking a cell value and apply different scales based on the table given.
Any help would be appreciated
HI Dear Friends,
I stumbled upon a file I was working on when I had to create a Drop Down list with additional set of functionalities. I have attached my sample work with what I need, any help would be greatly appreciated
I tried to strip down as much information as possible to upload on the...
I am having trouble converting month to Quarter
If you see example below. Jun-13 is Quarter 2-13
Jul -13 should be Q3-13 and not as shown below
Formula i am using is ="Q"&INT((MONTH(A1)/3)+0)&"-"&RIGHT(YEAR(A1),2)
Please advise what went wrong
Jul-13 Q2-13 WRONG
please find attached file. I have a cell which has a date formula. Now i need to adjust this formula in such a way that this cell will display no date if there is no value in corresponding cell
Hi, I have a column where dates appear as (28/02/2015 12:00:00 AM) when i download data from source. I would like to create another column which shows the date as (Feb-2015) and another column with preceding date , say in this case , it'll be (Jan-2015)
I can change these dates to the...
Hi All, I have used sumproduct formula in the attached file and it seems to be slowing down my file. I am aware of the work around steps like changing calculation to Manual, but i was wondering if there was a substitute formula that i can use, the spreadsheet will keep growing in size month by month
Could you please help with a formula for the attached file. The file infact is a miniature version of a massive line.
Formula to look up multiple conditions and then summing up values is what i am after,
but using sumif would slow down the file if the list is maasive
I copied data from several files and I need to make sure the Text I had copied in to different columns fall in the same row.
Using Column A as the base, I need tocompare columns C, E,G,I,L,N,P. Making sure all Text in the these columns fall in the same row as Column A. Once...
COuld you please suggest a rules for conditional formatting cells with a date range- 05-May-2015
If given date is 14 days before today- highlight green
If given date is 5 days before today-highlight yellow
If given date is today or past today-highlight red
Example - Today is...
Could you please refer the attached data and help me the best way to get this on a line graph ?
In the file I would like to compare "Revised" against "PLAN" and "LBE". There are quarterly figures appearing in the table as well.
I am just wondering what is the best way to present...
Could you please refer the attached Document and kindly suggest formulas for different types of averages ?
I have asked this another forum as well.