| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assign ID based on condition(criteria)
Hi i have somedata that looks like this: [image: http://img.photobucket.com/albums/v5...able/data.jpg] How can i assign an ID for each row to a columns next to the Column if the column E and column F had match certain defined criteria? This is how the criteria looks like: [image http://img.photobucket.com/albums/v5.../criteria.jpg] For example: Row 3 matched the criteria of Row 10866 since E3 is bigge than 3.121694 but smaller than 3.122874. Due to this reason, i need t place and ID "26" at H3. Similary, if others row in my database(1s picture) that matched some of the criteria , says, criteria 31(no shown in pic 2 but it is designed in that format), a 31 should place i the H columns of the corresponding rows. How can i achieve this in excel? Thanks -- changeabl ----------------------------------------------------------------------- changeable's Profile: http://www.excelforum.com/member.php...fo&userid=1571 View this thread: http://www.excelforum.com/showthread.php?threadid=27598 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| assign value based on criteria and total | Excel Discussion (Misc queries) | |||
| How to assign nothing into a cell under if condition? | Excel Discussion (Misc queries) | |||
| Assign auto numbers based on a condition | Excel Worksheet Functions | |||
| Can I assign a rank based on a cells' value | Excel Worksheet Functions | |||
| Assign value of cell based on text box | Excel Programming | |||
![changeable[_11_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
