• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. srinidhi

    Dynamic Generation of Col_Index_num based on selection

    Hi Excel Experts, I work with large data sets in excel and very frequently apply the Vlookup formula. In the Vlookup formula there is an parameter called Col_Index_num, where we key in the result column number. ex: Columns A:F, we key in as 6 , as need the result from F Column, this range...
  2. srinidhi

    Rolling Total from the last entered column

    Hi, A:L column has months like April'16, may 16..........April 17. As of now the data is filled only from April - July. I want the rolling total for 4 months. When the data is entered for Aug, the formula should sum up from May to Aug. When the data is entered for Sept the formula should sum...
  3. srinidhi

    Pivot Table Field List

    Hi, Is there any alternative for the default Pivot table Field List. My data is huge & it becomes very difficult to drag & drop filed in Values. Any suggestions & thoughts please. Any free Addins or VBA code to change the default Filed structure would be very helpful.
  4. srinidhi

    Count cells that has 0 from Right to Left

    HI, I need a formula which counts the number of cells which has 0 from right to left unit a first number cell (greater than 0) is reached: EX: Jan'16 Feb'16 Mar'16 Apr'16 May'16 June'16 Answer Count Blank 1 - 3 - 5 - 1 - 4 5 6 - - 2 1 - - - - - 5 - - 3 - 5 - 1
  5. srinidhi

    Sheet Activator

    Hi, Ninjas, My worksheet has a lot of tabs & i keep navigating to & fro a lot of times. I need a macro which activates the sheet when I place the mouse on the sheet Tab.
  6. srinidhi

    Macro in an excel for outlook.

    Hi, I am looking for a macro in excel for outlook. I need this macro to search for 2 specific email Id's & if those email Id's have an word document attached, then it need's to write the following in this excel. From the mail, the senders email ID, Date & the subject Line. From the...
  7. srinidhi

    Drop down list in user form

    Hi, Happy new year to all of you. I am beginner in VBA, I need help from the experts to create this user form. The user form should appear in the userform tab The names from colum A should be the drop down list in the userform name field In the userform only the current weeks dates should...
  8. srinidhi

    Nested if or conditions

    Hi All, need you help in solving the multiple if or conditions A1: Start Date (SD) B1: End Date (ED) C1: to have the result based on the following conditions. There are 3 conditions: If SD or ED is less than today "History" If SD or ED is greater than today "Future" If SD or ED is equal to...
  9. srinidhi

    Infograph

    Hi All, I just created an Infograph on the tiger Population in India. Please have a look at the attached file & let me know your comments & suggestions.
  10. srinidhi

    Fill other cells based on a condition in a cell

    Hi All, Cells for working are c,d,e,f. If there is YES in any cell{c,d,e,f}, then other cells should automatically display as NO I Tried the if or condition, it worked fines for cell c, when the formula is entered in d, it says circular error. The formula in c3...
  11. srinidhi

    Lookup values in a multiline cell

    I need to lookup values from a cell to another Multiline cell. ex: A B ID Name 001 ARUN OO2 Pawan 003 Sunil In C, I the ID, but the ids are in a single cell. C2 has ID number 001 & C3 has Id number 002 & 003 one below the other. In D, I want to...
  12. srinidhi

    Macro to copy based on a multiple conditions

    Hi All, I need macro to copy & paste data from one sheet to another. The macro should copy the data based on the following conditions: Column B has NEW EMP & Old EMP, Column C has Month, Column H has list of clients if NEW EMP is there in Column B & month is equal to current month, if both...
  13. srinidhi

    SUM the values from all the SUM Formula in a sheet

    My sheet has 5000 rows of data & in between there are sum formulas I want to sum only the values in the sum formula Ex: Numbers A1: A10, A11 =sum(A1:A10) Ex: Numbers A15: A30, A32 =sum(A15: A30) I would like to sum only the values in A11 & A32 & not the entire range from A1:A30 IS...
  14. srinidhi

    Numbers Text in Pivot Table (not Alphanumerical)

    I want the numbers (sum) as well as text to appear in the Pivot table, The column has Month & in some months the numbers need to appear & in some text, the base data from where the pivot is linked is in the same format like numbers for some months & texts for some month, but Pivot cant display...
  15. srinidhi

    Multiple Passwords for one sheet

    I have an excel which has data from A1:E800, the data consists of 10 departments. Every time, I create 10 different excel for each department. This is done as one department should not see the data of another department. It is a very time consuming task. My question is can I protect the sheet...
  16. srinidhi

    Paste values formulas simultaneously in different cells

    I have 2 books, Book1 & Book2. Both books have the same format. In Book1 & Book 2 C & D columns has values & E columns has a % formula, G & H columns has values & I columns has a % formula. Like this there is lot of columns that has values & there corresponding % formulas. Note: In Book1 the...
  17. srinidhi

    divide 2 numbers based on a condition

    I need to divide 2 numbers based on a condition A1 has June, B3:M3 has months, June, July, AUG.... There are numbers in B4:M4 & B5:M5. I need to divide B5/B4, if the month is June in A1, if it is July in A1, it should c5/c4 & so on
  18. srinidhi

    UDF

    I am using index & match formula for getting the data based on 2 condition. I want an UDF which will show the result (value) along the formatting (Cell Colour) from the source data in the result. Example if the source data cell has the text as SRI & the cell colour is blue, in the result I...
  19. srinidhi

    Macro to copy Paste from C to A

    I want help from experts in setting up a macro. The problem goes like this. I want to copy the text in C1 & paste it from A1:A23, next copy the text from c24 & paste it in A24:A46, next copy the text from c47 & paste it in A47:A69. There are about 5000 rows in C.
  20. srinidhi

    SumIfs or Macros

    https://docs.google.com/spreadsheet/ccc?key=0ArMlbNwyiUNHdDRjOVJrc1Q5bUZaa25JTWF0SExRNVE I have posted a sample file in the above mentioned link. Pls open the file & read the below mentioned line & please do post me your thoughts & solutions. The figures shld change accoring to the month...
  21. srinidhi

    Pivot table to be source data for another pivot table

    Hi All, Is it possible to use a pivot table as a source data for another pivot table. so that when I change the values in the data field in the main pivot table the same changes shld be reflected in the dependent pivot table.
  22. srinidhi

    Store formula in excel 2010

    Hi All, I have created my own tab in the ribbon, I use certain formulas very frequently. Insted of typing the same formula in different workbooks, I thought of creating the formulas & storing it in the the tab which I created . Ex I use this formula ...
  23. srinidhi

    Random Condition

    I have a few project beginning with ABC, & the other projects are EFG HIJ XYZ....... I have a few names Srinidhi, Rahul, Ram vineeth & Raj. 1st Condition, for project beginning with ABC - Srinidhi, vineeth & Rajname should not appear 2nd Condition, based on previous months data Ex if project...
  24. srinidhi

    How to add 21 working days to a start date

    I want to add 21 working days to a start date. Ex start date is 17-Oct-11 & I add 21 days then the end date is 7-Nov-10 which is a Sunday. I want to add only the 21 working days.
  25. srinidhi

    Duplicate Records

    I have a list of names in column A & Month Names in column B, some of the names are repeated every month. Now the challenge is to find out the duplicate records when I filter on a particular month.
Back
Top