Search results

Hi Chandoo Ninjas, I need help with a complex situation. I have tried many attempts but not helping!! I have a sheet (see attached) with the following columns: Sales Rep - contains names of sales reps Cust Name - contains names - not relevant to the problem Record ID - contains unique...

Hi Somendra, I changed the formula to this below on a new sheet and it works perfect... =IFERROR(INDEX(Data[Creation Date],SMALL(IF(FREQUENCY(IF(WEEKDAY(IF(Data[Creation Date]>=MIN(Data[Creation Date]),IF(Data[Creation Date]<=MAX(Data[Creation Date]),Data[Creation Date])),2)=2,Data[Creation...

Thank you for your help. This is perfect. Just one question: I can replace the $A2:$A$1436 by a table range or another named range to make this list expandable. Right? Thanks again, Ojas

Done.

Hi, I have table (Excel Table) with a column of multiple dates. These are record creation dates. The range of dates is for a specified fiscal year. (say, April 1, 2013 to March 31, 2014) I want to make a list (for data validation) that will do the following: 1. Build an array of unique...

Thanks for attempting to help @Faseeh. The data is confidential. But I understand and let me clarify. Lets say: I have 100 records named as Lead1, Lead2, ... , Lead100 in column A I have various dates against each of these in column B In column C, (and using the date value in column B) I...

Hi, I have a growing database of Sales leads and I have to calculate their eligibility for incentives. Now the incentive plan is in "tiers". Meaning Lead 1 to 5 (chronologically by attended Date) is defined as Tier 1. Lead 6 to 10 is Tier 2. Each "Tier" has a different amount to be calculated...