Filter data in Excel using formulas
I have an Excel table with the sale of water reservoir sitstems for 2022, the table indicates the names of the goods sold quantity and price, the goods are very frequently repeated,
to the example:
Tube size 280 mm, color yellow - 10 m = 1000 UAH
Tube size 300 mm, color green - 20 m = 1500 UAH
Tube size 280 mm, color yellow - 40 m = 1000 UAH
1 and 3 positions are repeated, I need to summarize how much each position is sold in a year, as well as how much it is sold in the product in size and color before the choice.
All in the 11,000 positions table, you need to make a filter using the formula, the one who is known on the axle will perform this task in a few minutes.
The table looks like the picture below.
I need to find out what was sold most often.
-
1 day11 USD
199 2 0 1 day11 USD
Good day . I am happy to help, I have a great experience working with the tables.
-
1 day11 USD
454 3 0 1 day11 USD
Welcome to! I can help you solve this task. Turn to
-
1 day11 USD
540 5 1 1 day11 USD
Good Morning,
I can do different ways to compare the results and have confidence in them.
-
1 day11 USD
345 22 0 1 day11 USD
Good day . I can perform my task. I have great experience. I will be happy to cooperate. Turn to
-
1 day11 USD
812 15 0 1 day11 USD
I do this with the formula, please.
• • • • • • • •
-
1 day11 USD
419 13 0 1 day11 USD
Welcome to!
I work with Excel and Google tables.
Ready to help with a formula or macro (scripts).
I will be happy to cooperate.
-
1 day11 USD
5859 345 0 1 day11 USD
I can calculate the necessary amounts after clarification of the details, because the example structure does not match the structure of the real table.
-
1 day11 USD
4461 102 0 1 day11 USD
Good day . I will be glad to help. I do everything quickly and efficiently! Ready to start right now!
-
1 day11 USD
3615 113 7 1 1 day11 USD
Welcome to.
I have a great experience working with Google Sheets and Excel.
Get acquainted with the project. Ready to help with the implementation.
Let’s talk about the details.
Current freelance projects in the category Accounting Services
Consultation on EDIN and B2B document exchange
33 USD
1. Consultation on EDIN It is necessary to conduct a consultation and assist with the following issues: the principle of EDIN operation; document exchange with trading networks and corporate clients; setting up the exchange process: orders; invoices; tax invoices; acts; other… Accounting Services, Consulting ∙ 4 hours 39 minutes back ∙ 4 proposals |
Filing a zero final declaration for a US LLC
71 USD
Hello, it is necessary to submit a final declaration for 2025 based on the template of the previous zero declaration for 2024 in order to officially close the company. Regarding payment, the cost is final, as the company has zero activity and I cannot incur any more expenses… Accounting Services, Consulting ∙ 1 day 17 hours back ∙ 7 proposals |
Building financial models (P&L + Cash Flow)We are looking for a qualified specialist who can help organize our business finances. We need to develop and implement two key reporting forms: P&L (profit and loss statement) and Cash Flow (cash flow statement). Please provide your work experience, what you have worked on,… Accounting Services, Data Processing ∙ 5 days 1 hour back ∙ 17 proposals |
Develop a dynamic financial model (in Excel/Google Sheets) for a network of autonomous fitness pods.
223 USD
Input parameters (Drivers): The ability to manually change the cost of 1 pod (CAPEX), the cost of rental per hour (399 UAH), the dollar exchange rate, the cost of land rental, and the loading percentage. Three scenarios: Pessimistic (20% loading), Realistic (30-35%),… Accounting Services, Consulting ∙ 5 days 4 hours back ∙ 23 proposals |
Need consultation from an accountant - Import VAT, duties, pricing, tax credit -Looking for a practicing accountant for import + VAT for a one-time consultation (~40 minutes). Topics: pricing and margin on imported goods, customs clearance (duty according to UKTZED, import VAT 20%, tax credit), choice of sales scheme — with VAT / without, wholesale and… Accounting Services ∙ 6 days 18 hours back ∙ 5 proposals |
Krasilov