Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Auto substract by comparing the category
I am having two sheets .Sheet one contains the following data
category Total amount Remaining category1 1000 category2 2500 category3 600 category4 9000 Sheet2 having Name category Final suresh category1 500 ravi category2 rajesh category3 ramesh category4 If i enter 500 in final for category1 then ,my formula should do Search for the category in sheet1 so now category is category1 so ,I have to populate totalamount-final=500 in remaining of category column1 in sheet1. please try to help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto substract by comparing the category
I don't understand so, if desired a better explanation and send me the
file. On Feb 12, 2:58*am, expert40 <np doubt wrote: I am having two sheets .Sheet one contains the following data category Total amount Remaining category1 1000 category2 2500 category3 600 category4 9000 Sheet2 having Name category Final suresh category1 500 ravi category2 rajesh category3 ramesh category4 If i enter 500 in final for category1 then ,my formula should do Search for the category in sheet1 so now category is category1 so ,I have to populate totalamount-final=500 in remaining of category column1 in sheet1. please try to help. -- expert40 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A SUB CATEGORY USING DATA VALIDATION? ALRDY USNG DV FOR CATEGORY | Excel Discussion (Misc queries) | |||
need held for auto date calculation for adding years and substract | New Users to Excel | |||
Auto populate a cell by comparing lists | Excel Worksheet Functions | |||
auto hiding rows under category heading unless cursor clicks on to | Excel Discussion (Misc queries) | |||
How do I substract numbers in range like this: Substract(a1..a10) | New Users to Excel |