How to increment entry point into table

%3CLINGO-SUB%20id%3D%22lingo-sub-1562457%22%20slang%3D%22en-US%22%3EHow%20to%20increment%20entry%20point%20into%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1562457%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%3C%2FP%3E%3CP%3EI%20need%20some%20help.%20See%20Below%20-%20I%20am%20inputting%20an%20initial%20value%20in%20cell%20%22C2%22.%20That%20value%20is%20used%20in%20cell%20%22H7%22%20as%20a%20table%20entry%20criteria.%20Several%20calculations%20are%20done%20and%20the%20results%20(Subtotal)%20is%20reported%20in%20cell%20%22I15%22%20which%20is%20returned%20to%20cell%20%22D2%22.%20More%20calculations%20are%20done%20and%20the%20results%20are%20in%20cell%20%22F2%22(Temp1).%20Then%20%22Temp1%22%20is%20used%20as%20the%20new%20starting%20value%20in%20cell%20%22C3%22%20and%20the%20whole%20process%20is%20repeated%20until%20all%20iterations%20are%20done%2C%20in%20this%20case%20the%20final%20answer%20is%20%22Temp14%22.%20More%20or%20less%20iterations%20may%20be%20done%20in%20other%20cases.%20I%20know%20how%20to%20do%20almost%20everything%20and%20everything%20works%20as%20needed%20except%20for%20one%20thing.%20I%20don't%20know%20how%20to%20increment%20the%20row%20number%20in%20cell%20%22H7%22%20so%20as%20to%20iterate%20through%20the%20data%20from%20row%20%232%20to%20row%20%2315.%20I%20assume%20this%20is%20possible%20in%20Excel.%20I%20would%20greatly%20appreciate%20any%20help%20with%20this%20problem.%20Thank%20in%20advance.%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ExcelTbl.png%22%20style%3D%22width%3A%20611px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F209927i51C577182E316818%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22ExcelTbl.png%22%20alt%3D%22ExcelTbl.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1562457%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1562825%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20increment%20entry%20point%20into%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1562825%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F747781%22%20target%3D%22_blank%22%3E%40JRW42%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAn%20image%20is%20only%20minimally%20helpful%20to%20those%20of%20us%20who%20would%20be%20interested%20in%20helping%20you.%20It's%20clear%20you%20have%20an%20actual%20spreadsheet...is%20it%20possible%20for%20you%20to%20post%20THAT%2C%20or%2C%20if%20the%20actual%20one%20contains%20confidential%20information%20of%20some%20sort%2C%20then%20a%20recreation%20without%20that%20confidential%20info.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOtherwise%20you're%20asking%20us%20to%20do%20that%20on%20our%20own%2C%20and%20that%20would%20involve%20making%20a%20lot%20of%20possibly%20false%20assumptions%20and%20thereby%20being%20unhelpful.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20said%2C%20I%20just%20want%20to%20make%20sure%20you%20know%20of%20the%20%3CSTRONG%3EROW%3C%2FSTRONG%3E%20function.%20Given%20your%20description%2C%20that%20might%20work%20to%20increment%20that%20row%20in%20H7...if%20that%20is%20the%20solution%20you've%20been%20looking%20for%2C%20fine.%20Otherwise%2C%20please%20help%20us%20help%20you%20by%20posting%20an%20actual%20workbook%20that%20incorporates%20your%20problem.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1563603%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20increment%20entry%20point%20into%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1563603%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3BThank%20you%20for%20your%20response.%20I%20have%20attached%20a%20Excel%20File%20that%20I%20tried%20to%20make%20several%20years%20ago.%20I%20finally%20gave%20up%20and%20wrote%20a%20small%20program%20in%20C%23%20to%20do%20this.%20That%20is%20where%20I%20got%20the%20idea%20to%20do%20what%20I%20am%20trying%20to%20do%20now.%20There%20is%20nothing%20confidential%20or%20even%20particularly%20interesting%20about%20what%20I%20am%20trying%20to%20do%20with%20the%20new%20spread%20sheet.%20I%20am%20just%20manipulating%20a%20point%20in%20space%20but%20I%20am%20trying%20to%20use%20the%20exact%20same%20scenario%20to%20increment%20or%20iterate%20through%20the%20values%20used%20to%20enter%20the%20table.%20So%20if%20you%20can%20offer%20any%20help%20with%20the%20attached%20Income%20Tax%20file%20I%20can%20kill%20two%20birds%20with%20one%20solution.%20I'm%20actually%20not%20a%20hunter%20so%20I%20don't%20kill%20birds%20or%20any%20other%20animal%20but%20I%20really%20will%20and%20do%20appreciate%20your%20help.%20Thanks.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello everyone,

I need some help. See Below - I am inputting an initial value in cell "C2". That value is used in cell "H7" as a table entry criteria. Several calculations are done and the results (Subtotal) is reported in cell "I15" which is returned to cell "D2". More calculations are done and the results are in cell "F2"(Temp1). Then "Temp1" is used as the new starting value in cell "C3" and the whole process is repeated until all iterations are done, in this case the final answer is "Temp14". More or less iterations may be done in other cases. I know how to do almost everything and everything works as needed except for one thing. I don't know how to increment the row number in cell "H7" so as to iterate through the data from row #2 to row #15. I assume this is possible in Excel. I would greatly appreciate any help with this problem. Thank in advance.

 

ExcelTbl.png

2 Replies

@JRW42 

 

An image is only minimally helpful to those of us who would be interested in helping you. It's clear you have an actual spreadsheet...is it possible for you to post THAT, or, if the actual one contains confidential information of some sort, then a recreation without that confidential info.

 

Otherwise you're asking us to do that on our own, and that would involve making a lot of possibly false assumptions and thereby being unhelpful.

 

That said, I just want to make sure you know of the ROW function. Given your description, that might work to increment that row in H7...if that is the solution you've been looking for, fine. Otherwise, please help us help you by posting an actual workbook that incorporates your problem.

@mathetes 

 Thank you for your response. I have attached a Excel File that I tried to make several years ago. I finally gave up and wrote a small program in C# to do this. That is where I got the idea to do what I am trying to do now. There is nothing confidential or even particularly interesting about what I am trying to do with the new spread sheet. I am just manipulating a point in space but I am trying to use the exact same scenario to increment or iterate through the values used to enter the table. So if you can offer any help with the attached Income Tax file I can kill two birds with one solution. I'm actually not a hunter so I don't kill birds or any other animal but I really will and do appreciate your help. Thanks.