Hi all,
i have a table with some sh*ts in it...
One of my cells is called Capacitors and the number of the cell is 202600. This is the default value.
How can i increment this value?
For example:
I have capacitors in one cell with this value => 202600.
But i want to put capacitors in another cell and i want the value to be 202600 + 1 => 202601
Another cell with capacitors with 202600 + 2 => 202602
And so on...
Anyone an idea?
Capacitors.JPG
Last edited by LUBObe; 03-14-2013 at 02:46 PM.
Not sure if I am understanding you correctly but you could replace the +1 and +2 with Row()-x where x would be 4 to result 1 if you had this formula in Row 5
Let me show you another picture to understand it right...
Capacitors2.jpg
Just use drag down method, it will work.
202601 capacitors
202602 capacitors
202603 capacitors
This method won't work for me, because the cells aren't one after one... They will be randomly picked... For example => A1 will be capacitors with 202600 value, the second cell would be for example A15 capacitors and the cell's value should be 202601...
Please send me a excel file that will make me very clear.
eXcel_File_1.xlsm
Here is the file...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks