Search results

Hello, I have table with the following info: * date (June-September) * market (3) * products (30 units) * prime cost * sale price. I need dynamic chart so I can select product and see the following: * Sales in only one market (bar chart) * Prime cost of only above market (line chart)...

Hi, I've just noticed I wrote almost the same formula as Narayan, how should I delete my post?

SirJB7, a) this report is updated once a month, I save old data as values to different workbook and add new numbers to be calculated. b) usually I do not change turnover discount values, but each new report needs to be recalculated since new data comes without discount c) I perform few more...

Hello everyone, I have sales report with more than 125k rows. Each row must be multiplied by turnover discount (15% - 0,85 and etc.). Since every row must be matched by product and seller, this means A LOT OF INDEX and MATCH. Is there any way to overcome this and speed this process up...

Hello, Found this question on other board with no answers. Maybe you can help - same problem to em: "I have searched this forum and the web, thinking this must be a quite common problem, but have had no luck. I have created an ODBC conenction to get Data from a database on a shared drive...

Hello Narayan, I want to thank you for your help. I successfully applied your solution to my data table :). Really appreciate your help!

Yes :), but whenever I add additional data to my table, I'l have to update formula range manually? You are being very very helpful!!!

I'm back with source file :) Here's the link: https://docs.google.com/open?id=0ByqDLydmf7lVX21MMFhIVWJsVFk Could you please overview "COUNTIFS" column. The only problem now is that COUNTIFS does not ignore rows before #ThisRow and counts all cells in that column.

NARAYANK991 I really appreciate your help but now I'm facing another problem. Since my data is displayed as Table I cannot use Cell reference, so how do I lock my range from #ThisRow till last Row on Table and so on till very last record?

Additional columns can be used if it helps and makes calculation simpler. Also if you could upload your sample file with single-cell formula it would be very interesting to see how it works since I cannot manage to apply it with my data. Table part is a bit confusing :). Thanks in advance.

Hello, I am trying to match sales records (day + product) and return client, but some sales overlap. This returns me the same client for two different entries. I am sure there is some formula to avoid such thing or to return unique value. Although I found some array formulas on Google...