Recent content by Jeffrey Lebowski

Narayan, This looks promising. Can you explain what the RangeParameter does? Thank you everyone for the input!

Hi there, I have a pretty large macro that I run to validate the accuracy of data in a file. Right now the code has 100 + formulas referencing static ranges and performing calculations. The only problem is as the file grows in size with time, these formulas will need to reference the entire...

I want to build a formula that I can drag down to replicate the string of dates in the attached file. Based on a start date and anniversary date, I would like to have the date increase each row by one month, with the same day value as the anniversary date, unless that day falls on a weekend or...

Hi, I would like some help using multiple nested IFs and concatenation to develop timestamps. See the attached file. Column A: The timestamp "code" (d=days, h=hours, m=minutes, s=seconds) I would like applied in concatenation. Column B: The time data, in hours. Column C: My current solution...

Would SUMPRODUCT still work if we added another level? So imagine we add another table: Table 1 contains a list of Car Parts and their respective cost. Table 2 contains a list of Cars, and the Car Parts that belong to them. In the sample file, each Car has 2 Car Parts. Table 3 contains a list...

great explanation!

Do you mind helping me understand the logic of the formula?

Awesome, thank you so much!!!

Hi, I am having trouble conceptualizing which formula or combination of formulas to use in this scenario. . . Imagine 2 data sets that come from 2 different database tables: Table 1 contains a list of Car Parts and their respective cost. Table 2 contains a list of Cars, and the Car Parts...

Thanks Luke & Narayan!

Luke, Can you tell me how you created that calculated field? That is exactly what I want to do, just have it replicated on a larger scale. Did you create the field like this?:: I am wondering if there might be another way to create this calculated field without referencing each individual...

Hi Everyone, I have attached a sample of what I would like to accomplish using a Pivot Table. Say I have a group of individuals to whom I would like to distribute samples of my products. Say that I have a limit of 2 on how much of any product I should give any one individual. The table in the...

You're right. My solution to his problem probably went in a direction that was not the best, most efficient and simple solution. So please allow me to take a step back with this explanation: The first tab of that file is what my friend sent me. He asked me how he could sort by column B ('Sbtl...

Hi All, I have created a materials order tracking log (attached) for a friend. The ‘Orig’ tab is what he gave me, and initially had used colored rows to separate the different systems (column F) which caused him problems when sorting. My solution on the ‘Work’ tab was to conditionally format...

Thanks Hui. Any chance you can provide the workbook used for the link you gave above?