Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Auto populate randomly
I have one sheet which have the set values as follows
category Total amount category1 1000 category2 2500 category3 600 category4 9000 I have other set of values as Name Amount Allocated finally suresh 1000 ravi 800 rajesh 479 ramesh 3500 Is there any process to auto populate randomly the Allocated finally by taking the amount from second set of values and see whether the sufficient amount was there in first set of values if sufficient amount is there allocate from one ,if sufficient amount was not there then we have to allocate from two categories or three or 'n' and print the categories in other column(i.e from what categories the amount was allocated) For Example: If i consider Ravi he has 800 to be allotted. Then I should be able to check the first set whether 800 is present. If exact 800 is present in one category allocate that category to ravi. If 800 was not present in one category allocate from two categories to ravi If from all categories if we sum and we get less amount than to be allotted then we should print error. Please try to help or show me the way to proceed Attachment 141031 |
#2
|
|||
|
|||
Is there any process to auto populate randomly the Allocated finally by taking the amount from second set of values and see whether the sufficient amount was there in first set of values.
__________ memory foam mattress | adjustable mattresses | memory pillow |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto-update Fill Series in column that has randomly spaced blank c | Excel Discussion (Misc queries) | |||
Auto populate name | Excel Discussion (Misc queries) | |||
Randomly populate a list into empty cells | Excel Discussion (Misc queries) | |||
Auto-populate, Auto-copy or Auto-fill? | Excel Worksheet Functions | |||
Need to randomly populate a 10x10 array of cells with 100 names - 5 people listed 20 times each... | Excel Programming |