200

Hi Expert, Apologies for consuming your valuable time. I have a large Data base which is showing with Month as well as client. (Following example Month, Client and amount) I want to show to use another sheet as voucher format where All transaction e.g. Month of Jan-18 and a Client of ABC to be...

Hello, I want to build a simple sheet to manage inventory for rental business with 3 warehouses. Items can be pulled from, and return to any warehouse. When the quantity of items is entered, I want some kind of button to appear where I can choose which warehouse the items will pull from...

Hello, Please help me with given sample tables below. First table shows the original datas... Second table is the results what I wanted to get by clicking the button all datas will randomly changed with below conditions. 1. Column A and Column B will be related datas.(If A1 goes to another row...

<tbody> Projected price Inflation Date Rate 1/1/2019 5% 1/1/2020 5.5% 1/1/2021 6% 1/1/2022 6.5% Price amount by unit Date Amount Desired result 1/1/2019 1,000 1000 x 5% 1/1/2020 1,200 1,200 x 5.5 1/1/2021 1,500 1/1/2022 2,000...

Hi, Ive been working on a a dynamic INDEX / MATCH, which I've sovled. How ever the values I'm returning on not always unique, and I want to lookup other values from the same column/row. <!--[if !mso]><style>v\:* {behavior:url(#default#VML);}o\:* {behavior:url(#default#VML);}x\:*...

I am trying to accomplish the following; Cell C11 Change to 50%, 40%, 35% or 30% if cell C10 is 50,000, 100,000, 150,000, 200,000

I have tried a number of formulas but don't get it right. I'm after: iF A1 is greater than 0 but less than 29, 1 IF A1 is greater than 30 but less than 100, 2 IF A1 is greater than 100 but less than 200, 3 etc Assistance certainly appreciated Thanks

Hi all, I have a worksheet where each row represents a location. Column C lists all of the employees at that location separated by carriage returns. Is it possible for the sheet to split out the employees and display individual lines for each employee? <tbody> Location ID Location Employees...

I need to identify transaction amounts in 2 different columns as shown below, either debit or credit will have an amount. I need to identify how many transactions are below $5000, $25000, $50000, 100,000 & 200,000, so any help would be appreciated <tbody> DebitAmount CreditAmount...

Hi All, can anyone assist with a formula for the following : <tbody> 609 C E F G H i J K L S T U V 610 Description Prop. Vat Dr Amount Vat Cr Amt Vat Total Days 5% Total 611 2,668,666.46 612 2017-01-30 Loan - In Eaton n 200,000.00 200,000.00 115...

Hello I cannot figure this out, hoping you will:) I have a table consisting of Art.no./Month/Volume/Price <colgroup><col span="3"><col></colgroup><tbody> Art.no. Month Volume Price 210015 1612 200 190,00 210015 1702 200 200,00 210015 1705 200 200,00 </tbody> In Another...

Dear Mr. Excel Can you please help me to prepare the data on excel sheet as per attachment. Regards <colgroup><col span="4"><col><col span="2"><col><col><col span="5"><col><col><col><col><col><col span="2"><col><col><col><col><col span="2"><col><col><col><col><col><col...