How can I place a known value in an already complete table.

[hansen]

I have a table with values ascending from A1 to A8, then continues ascending into the next row from B1 to B8. A8 is lesser in value then B1. This continues with row C,D ... for some more rows.

Now the complication is that I have a certain number which lies between two of the numbers. So I inserted columns between every column of the table, but do not know the function for the value to find its location within the table.

For eg. row 1- 2,4,6,8 10
ROW 2- 12,14,16,18,20
......
Row 6-52,54,56,58,60

I want to find the location of number 17 to paste it there in between 16 and 18. The table has 5 columns and 5 blank columns between them.

Kindly help, if there is a solution to this type of problems.

[davesexcel]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[teylyn]

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!