Search results

Hi Luke and Chirayu. Both your solutions work so thank you both so much for that. Luke I hadnt even thought about the other 2 options, as the idea is to identify emerging and disappearing issues in particular, but I will think about that as it would be useful. Thanks again for your help guys...

Hello. I thought I had been given the answer to my question, but looking back I didnt (my fault for not explaining) and now I need this information to work again. I have attached a sheet with an example of my data and then what I need it to do. I think its an IF function. Basically trying to...

YES!! YES!! That's it :) How did you manage it??? I don't even know where to start

Hi ... I want to look over 6 months comparing the first 4 months to most recent 2... The aim is to highlight where there have been 0 sum in the first 4 months But anything over 0 in the following 2 months maybe using the phrase Yes for the true result !!

Can someone help please? I am trying to get the correct formula to compare a set of months by another set of months. I have tried SUM and IF but must be doing something wrong as it wont work :-( I have attached an Excel sheet with some dummy data to demonstrate). I dont use VBA but want to...

I am attempting to break the formula down and understand it bit by bit, so it may take a while for me to come back to you :-)) E

Wow! That is absolutely amazing! Thanks so much I am blown away by your expert knowledge... I'm gonna try to understand how this works so I can learn from you guys... E

Thanks Narayan I'll have a go and let you know how it goes :-) E

Hello all I am trying to workout how to select lines of data where the time period covers between two time periods 2300hrs and 0600hrs. I have 4 columns with many lines of data but have possted 2 example lines as follows:- both include part of the period I want to capture! A=01/01/2012...