Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Adding cells until they are greater than a lookup cell and returning a value
I have spent hours on this, and I believe I need a match, offset, index, but not sure which order.
I am trying to total cells until they are greater than the value in another cell and then pull in the date from an adjacent cell when they are. I have dates in E2 to R2 I have numbers in E3 to R3 I have a value in B3 I want to total E3 to R3 until the sum is greater then the value in B3, when it reaches that point, I want to pull the corresponding date from cells E2 to R2. The result needs to be in cell A3 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding cells until they are greater than a lookup cell and returning a value
Hi,
Am Mon, 17 Feb 2014 15:14:34 +0000 schrieb thunderbirdlindy: I have dates in E2 to R2 I have numbers in E3 to R3 I have a value in B3 I want to total E3 to R3 until the sum is greater then the value in B3, when it reaches that point, I want to pull the corresponding date from cells E2 to R2. The result needs to be in cell A3 if you put your data into columns you can use a formula. Look he https://skydrive.live.com/#cid=9378A...121822A3%21326 for the workbook "DateCheck" With your data in rows you have to solve it with VBA Regards Claus B. -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning data of multiple cells for lookup of mulltiple cells | Excel Discussion (Misc queries) | |||
How to check all three cells are greater than 0% and then lookup v | Excel Worksheet Functions | |||
returning multiple cells for a single lookup | Excel Discussion (Misc queries) | |||
lookup returning several cells | Excel Discussion (Misc queries) | |||
Adding cells with alphabet and returning a numbric value | Excel Worksheet Functions |