Search results

----------------- Hi, Wow... you are Ninja.... Regards, Tarun

----------------- Hi, Though this is interesting, but the problem is with combined names like - 'Amitabh, Shah' and if i slice for "Shah", then this row element is skipped. Regards, Tarun

-------------- Hi Narayan, Though it works, but how to clear/ refresh filter every time? Regards, Tarun

Hi, I have 100s of rows of tabular data. Requirement is - user will choose the muliple drop down in filter and as per selection the result should populate. Wondering if this is possible in excel? Out of huge data - as per selection (assuming underlined are selection) - can the result be...

super -thanks

Hi, We can use Sumproduct or Sumifs formula to get conditional sum from a row. But what if formula has to choose which column to take for making conditional sum? Attached is excel file as an example. Our source data is spread across 3000 rows and 200 columns & output data template is...

Hi, In an excel sheet - data is extracted from some where using some forumlaes. Now with this data dump - i need to segregate data as less then 95 in one area and more then 95 in one area in the same sheet itself. Since it is daily activity - i do not wish to do it manually. b/m is data...

Hi Narayan, wow... thanks... <Regards> Tarun

Hi Narayan, First you told Second i got it: =SUM(IF(A2:A11={"A","B","C"},B2:B11,0)) but not getting 3rd and 4th: Count of India - A,B & C Sum of India A,B & C <Regards> Tarun

Hi, I have got b/m data in columns A,B,C Options Sum Country A 500 India B 400 India C 600 India D 400 India A 500 Others E 200 India A 400 India B 300 Others B 600 Others C 500 Others I want to calculate - Count of A,B & C Sum of A,B & C Count of India - A,B & C Sum of India...

Hi Narayan, Regarding Bucketing -you understood correctly. Coming back to India - if in case data is not fitting in any bucket then it should give some error or comment like "0 case". <Regards> Tarun

Hi Narayan, Formula created by my friend is not accurate. Countries Database is the Bucketing part- which can vary from country to country. Ideally i was looking out that formula should refer to (Countries Database from) L1:T7 so that if bucketing changes for one country - its resulting...

Hi Narayan, woww...formula is bouncer to me - but - this is indeed working - but i what if countries database like Jordan changes? <Regards> Tarun

Hi, regret inconvenience. here is the link of the file https://docs.google.com/spreadsheet/ccc?key=0AkO2OWXsrX1idDdMR3JMSHdDSmVfX2lqeGU1X2F1NHc <Regards> Tarun

Hi, I have got a query in excel lookup. (i wish here an option should be there to upload file for better clarity) i need to lookup data with database and i need buckets for it. eg: Database: India 1 3 12 30 50 100 500 1000 Jordan 1 3 12 30 50 100 500 1000 UAE 1 3 12 30 50 100 500 1000...