Hi, Just want to fill the data to the ledgers from daily transactions with In/Out values, and if there is Inward transaction, the value should go to "In" column and if there is Outward transaction the value of transaction should go to "Out" column with the filtered data, so I'm using filter function but I'm not able to fill the values conditionally to "In" and "Out" columns. Please suggest me any solution. (It's Google Sheets)
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Filter function to fill the data to inventory ledger with In/Out condition from daily transactions sheet
- Thread starter Mohsin110
- Start date
Excel Facts
Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
Similar threads
- Question
- Replies
- 0
- Views
- 114
- Solved
- Replies
- 1
- Views
- 72
- Replies
- 0
- Views
- 110
- Question
- Replies
- 0
- Views
- 227
