Search results

Hi bs, In your first post, you have the day of week (e.g. Monday) included, but in your last post you are indicating that just the date (e.g. Jan 17) is what is in the format. Which is it? Both?

Hello TonyNZ, Welcome to the forum! Can you provide some examples of your data? Specifically, I would like to know how the data is setup if the date range spans months (such as Jan 17 to Feb 23). Remember to include all possible variations of the format of your data. Cheers, Sajan.

Hello Katya, Thanks for the feedback. Glad your problem is solved. Regarding MATCH and INDEX functions, there are many resources available on this site (and elsewhere) that explain them. However, if you have any specific questions, please do not hesitate to ask! Cheers, Sajan.

Hello Prisoner (of Zenda?) Welcome to the forum! Can you upload a sample file? (Remember to remove any sensitive info since this is a public site.) I am not sure I follow your description about how customers are to be grouped. Are you saying the grouping already exists, and you are trying...

Hello Pam, Did you have a follow up question? -Sajan.

Hi Greg, See if the following article helps you: Charting with non-contiguous data Cheers, Sajan.

Hello Katya, Welcome to the forum! To get text values displayed, you can use formulas to get the desired results. To get the Pivot Table effect, we need to break up the problem into three pieces: Display the Row Headers (in your example the Names) Display the Column Headers (in your example...

Thanks for the feedback! Glad your problem is solved! -Sajan.

Hi, Yes, it would. Feel free to upload a sample workbook and I would be happy to take a look. Cheers, Sajan.

Hello Abhi, Try: =LOOKUP(15, {0;10;20;30;40}, {"A";"B";"C";"D";"E"}) here 15 is the age Change to cell references as needed. Cheers, Sajan.

One more observation... Since you are getting errors when you have a subtraction, please check whether you have non-numeric values in ALL_Data[AD] or ALL_Data[OD]

Thanks for the feedback! Glad it solved your problem! All credit to Narayan!

Perhaps I am overthinking this... but when you say add 15 years, do you mean 8/11/2028 or something else that factors in leap years, etc.?

See attached... with Narayan's formula added. The cells with errors are those where a code was not found. You can use IFERROR(...) to handle them, if needed.

Please attach a sample workbook, and we can demonstrate the formula in action.

I noticed that you have a reference to US in the first formula but US_2 in the second formula.

Thanks for the feedback! Glad to hear that your problem is solved! -Sajan.

Instead of full column references, can you refer to a specific set of cells for the codes? Feel free to attach a workbook if that above suggestion does not make sense.

In that case, Narayan's solution above should work for you. Change 999 to len(cell) if needed.

Can you clarify your requirement? You are checking a given string for the list of codes. If a given code is found, you want to return that found code value. What should happen if multiple codes match? Return the first code found?

By the way, what should happen if your input value is an integer (like 2). Should the product be zero?

or perhaps not... re-reading the original post, I think the OP wants to find if someone will turn 60 years old in 2014 and not any earlier!

perhaps it should be YEAR(A1)<=1954, assuming that if someone is 75 years old, that is still OK.

Hi nejjoan14, If column A does not have dates filled in, you would use something like: =SUMPRODUCT((LOOKUP(ROW($A$5:$A$46), ROW($A$5:$A$46)/($A$5:$A$46<>0), $A$5:$A$46)>=$B$3)*(LOOKUP(ROW($A$5:$A$46), ROW($A$5:$A$46)/($A$5:$A$46<>0), $A$5:$A$46)<=$C$3)*($D$5:$D$46=$A49)*($H$5:$H$46))*24 If...

@clumpa, To get the product, you could try something like: =MID(J10,1,FIND(".",J10)-1)*MID(J10,FIND(".",J10)+1,255) where J10 has the number I did not understand the rest of your question. I would suggest posting a sample workbook with an explanation of what you are after. Cheers, Sajan.