Search results

I added a new column for FE values and updated pivot for my purpose. Thanks!

I do not have Financial Year in my data. I can create the same, do you know any formula. Thx

I have data in an Excel spread-sheet for 2017, 2018 with start and end dates. The data contains the number of donuts consumed in office by department. I created a pivot and a column graph for donuts consumed by each department. I need to split the Pivot and graph by Department and Financial...

I am using Excel 2013. My pivot has the following columns Sales in Continent and country Cosumables Perishables ======================== ============= Country Name...

This did not work. Counts all cells. Thanks!

This worked so far. Will keep working on using this formula. Will revert if there are issues. Thanks!!

Both formulae give count as 0. As i mentioned, the row can have different values, 0 or - or non-zero values. All of them derived from formulae shown above. Thanks!!

N1N2N3N4N5N6N7N8N9N10N11N12 (0) (0) (0) (14) (14) (14) (14) (14) (14) (14) (14) (14) #N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A Formula in each cell: =ROUND(INDEX(INDIRECT(A$3&A$2),MATCH($C$4&"XYZ"&$C$2&$C$3&$D3&$A3,INDIRECT(A$3&"!A:A"),0)),0) N1 to N12 are columns The first...

This did not work. The cells are filled in with vlookup formula. Your suggestion counts even blank cells, a row with 12 columns, all blank cells gave me 12 as result. I need count only from cells which are 0 or non-zero and eliminate "-" from counts. Pl note all the values are dynamic and...

This did not work. Pl note that the values in the worksheet are derived from lookup/formulae. Each cell is filled with formula. Irrespective of value 0 or - or non-zero, there is a formula in the cell. I have 12 columns and am getting count as 12 irrespective of the value.

I have multiple rows in excel workbooks. Rows in the workbook are filled in with values derived from formulae. Data in these cells is populated (from underlying tables) when i select certain input combinations in the workbook . The Rows in workbook have 0 (zero) or - (dash) or non-zero values. I...

I have an excel sheet with these details: col A has items (>300), col b has week numbers (1-52), col c has number of items sold in the particular week. I need to filter Col A for a select 10 items, for a few weeks (in col b) and select a few items from Col C. How can I do it.