Search results

Wow guys thank you so much you are really great in this kinds of stuff.

Hi p45cal, thanks this is awesome. I like it! Thank you so much

Hi there, Thanks for sending. This is great however I am looking for a simple solution if there are any as the user of the file will be an entry level. It will be hard for them to use a power query

Hi there, Good day! Hope you are well. I am pretty knew to this forum. I have a question and attached the file for your review. I would need assistance in counting letter B from Column B to GD. But the trick is I would only need to count B if its 7 days in a row or more then minus 184 constant...

Hi vletm, this was very helpful this saves me alot of time! Great work! Thank you so much!

Hi all, Hope you can assist me in my problem, been thinking on this for a while now. Here how it goes and I have attached the file : If possible I would like to have the formula in column I (Office Hours Time PO Creation Start), if column B falls on Friday and time was 9:00 pm, column I...

Hi vletm, thanks for working on this. its a different data set, they just wanted me to replicate that chart

Hi There, I have a concern that I would not know how to solve. Using the excel file, I am trying to replicate the chart in the PDF file. Let me know your thoughts on how to replicate it. Thank you so much in advance. Regards, James

Hi Bosco, You can try this formula : Concatenate Column : =B2&C2&D2&E2&F2 Checker Column : =IF(COUNTIF($C$2:$C$6,C2)>1,"Duplicate","Not Duplicate")

Hi Lasantha, In order to have a bell curve like the attached file, your data should be more precise. To get the output you want you need to get the average score and the Standard Deviation for your data. To get the Average Score or Mean of your data you need to get total score divide by Count...

in the attached file, if you look at the sum column, that's how I want the formula to execute when I drag it down. hope that helps?

Hi, Is there a formula for sum in excel that would change depending on the date: i.e. Day 1 = 1 outcome Day 1 = 1 Day 2 = 2 outcome Day 2 = 3 Day 3 = 3 outcome Day 3 = 5

Hi John / Hui, Thanks for the responses. Your formulas are really helpful I was able to submit it on time.

Hi Hui, Yes I've done that but since email formula is dependent in the phone number formula, the email column will show value error

@Hui and @john how about when I don't have phone number : like this Virginia A Rice gini.rice@crescenthomes.net http://www.crescenthomes.net it shows error

@Hui that is the format I usually get it

thanks John

Hi Mariya, In order to see what you really want might as well send the file. It would be harder to visualize your output without seeing anything

Thank you all for the assistance, everything is working correctly. But I chose to use B12=INDEX($B$1:$B$6,SMALL(IF($A$1:$A$6=A12,ROW($A$1:$A$6),""),ROW()-11)) Everyone is so helpful in this site. :)

Hi Excel Experts : I would like to ask if there is a formula to segregate this text sample into columns : Caleb Pearson843-619-1504askcpteam@gmail.com in to Name Column / Phone Column / email / website

Hi Naresh, This is great, I think this is the one I need

Hi Excel Ninjas, Is there a formula in excel that could do a lookup for 1 reference but would have different values? I might be sound confusing but I have attached the file for you to see and check what do I mean.

Fantastic Narayan and Pecoflyer! It is working!

Hi, I have a question, I would like to create a formula that would show week range of monday to sunday. I wanted an output that shows like if date is 1-November week range should be Oct 30 - Nov 5. I have a formula in the attached file but not really what I wanted output.

Hi Narayan, Thanks! this makes my life easier! You are awesome.