I am attempting to create a table in excel that will automatically fill out another table depending on the outcome. For example, if A3> 0, then A1, but if it is not, then check A4>0, then A4, etc. I've attempted it in this manner so far, but when I get past the first one I always seem to get repeating outcomes. For example, if A1=0 and A2=0 , then it will move to A3 but A1 and A2 will have the same result as A3.
If you don't understand, then I will try to elaborate or show a photo.
Last edited by markmkramer; 10-25-2012 at 06:07 PM.
Try showing a spreadsheet (Go Advanced> Manage Attachments) Show what you have and what you want.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
I have attached an example of what I want to see. My coding has caused duplicate entries in the receipt section.
Last edited by markmkramer; 10-25-2012 at 04:21 PM.
In G6, copied down
=IFERROR(INDEX(A$4:A$11,SMALL(IF($E$4:$E$11=0,100000,ROW($E$4:$E$11)-3),ROW(A1))),"") entered as an array (Use CNTRL SHFT ENTER instead of ENTER. You'll see {} around the formula)
Similar formulas in H6 and I6
In J6, just as a check, used
=IF(ISNUMBER(I6),H6*I6,"") copied down (not an arrayed formula)
See attachment
Does that work for you?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks