Search results

Yep that is perfect, I cant believe I didn't think of that already. Thanks so much!

Wow thanks so much everyone for the excellent feedback communication

Sorry @pecoflyer, I had the source data in a hidden tab. I have unhidden it in the attached version

I have sheet containing a group of columns & rows that are based on a simple IFERROR formula, which populates my sheet based off of data from another sheet. If the data rows in the other sheet are blank then my sheet returns empty cells as required. The issue I now have is that I have added...

Hi again team, thanks so much for the help with the formulas. I ended using a TRIM function to get the desired result as I found the string the easiest to follow and explain. The end result data summary is now working well, however I have a side issue that is related to additional incomplete...

Thanks @bosco_yip for your very detailed response. The formula you provided is very complex and I am trying hard to understand all the sub-strings. It does work, however for my own learning I am trying to understand this a bit better so I can follow all the steps

Thanks for the responses. I was trying to use a combination of LEFT & FIND formulas but was getting stuck

Hello there, I need some help with trying to split specific data from cell into 2 different cells. For example I some summary information in 1 cell which needs to split into 2 different cells for deeper reporting purposes. The data example is a follows: A1 Current State A2 - Date in market...

Thanks for the response. One of my collegues actually just responded and supplied a very easy formula using the SUMIF formula that i thought i should share. This works really well =SUMIFS(I3:I23,F3:F23,B2,G3:G23,"<"&B1,H3:H23,">="&B1)

As a follow on I have written the following formula, however this is quite long and only looks up 1 of the 7 tarriffs. =IF(AND($B$3="NSP56",$B$1>=0,$B$1<=2000),S3,IF(AND($B$1>=2001,$B$1<=5000),S4,IF(AND($B$1>=5001,$B$1<=9999999999),S5,"")))

Hello I need help in creating a formula that looks up a tariff and cross references it with 1 of 3 usage scenarios to return a monthly fee. As per the attached the user would enter a usage value in B1, and select the Tarriff in B2. Dependign on their data entry the formula needs to lookup the...

Hi Narayan, As there will only be 5 years applicable (2015-2018) it seems overly complex to add the MIN/MAX references. To be honest i don't really understand what the formula is about, with all the MIN/MAX number calculations

Thanks Narayan, however I was looking at returning the set values for each of the 4 years, as there is no projections beyond 2018 ie 2015= $5000 2016 = $10000 2017 = $15000 2018 = $20000.

I am trying to put together an analysis sheet, and i need to look up a date column, and if the year equals a pre defined value i need it return a set value. Example: Column I contains contract end dates in the format mm/dd/yyyy. If the date contract ends in 1 of four years, either 2015, 2016...

I have been using vlookups for most of my day to reporting tasks, but am coming across some errors, and a colleague said using Index/Matching formulas is much better. A problem I have is with the below formula because the IDs are slightly case sensitive i.e. "001a000001KYl9a" refers to a...