• 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. G

    Looking to sub-contract (hire) Excel/Google Sheets experts for regular side jobs

    @Preet Inder , Still do u need help on this?
  2. G

    Need If Formula

    Mohammad Yonous, Try this formula...
  3. G

    How to count number of rows in multiple sheet names in a file and produce summary table

    Hi Singh, Sorry for the delay....Give me sometime....
  4. G

    How to count a word occurrence in a cell? or a Range?

    Hi Ratan, Please use the formula below...File attached for your reference. =SUMPRODUCT((LEN($A$2:$A$4)-LEN(SUBSTITUTE(LOWER($A$2:$A$4),LOWER($E3),"")))/LEN($E3))
  5. G

    Table in excel

    Hi Saurabh, Hope, this will help you. I used the formula below.... =IF($B5="Air",SUM(($D5*'Box Master'!$E$2)+('Main Sheet'!$E5*'Box Master'!$E$3)+('Main Sheet'!$F5*'Box Master'!$E$4)+('Main Sheet'!$G5*'Box Master'!E6)),IF($B5="Surface",SUM(($D5*'Box Master'!$F$2)+('Main Sheet'!$E5*'Box...
  6. G

    How to append multiple sheets in a file?

    Hi Singh, Can you please put more information. I am not understanding completely. Thank you.
  7. G

    How to count number of rows in multiple sheet names in a file and produce summary table

    Hi Singh, Hope! the code below will help you. I didn't write the code to create a sheet "Summary". I did it manually. Option Explicit Sub Summary_Dashboard() Dim LR As Variant Dim WS As Worksheet Dim WS_Count As Integer Dim i As Integer, j As Integer WS_Count = ActiveWorkbook.Sheets.Count...
  8. G

    Conditional Formatting of Cell Ranges

    Hi Pete, Select range A3:C5, -->Conditional Formatting -->New Rule -->'Use a formula' -->ok -->apply Do the same process for Jan-17 (D3:F5) & Feb-17 Regards, GK
  9. G

    Index / Match Functions

    Hi Kishore, suggestion: 1. If you want to look up a value from left to right, use VLOOKUP. Ex: Your scenario 2. look up a value from right to left use, combination of INDEX and MATCH function.
  10. G

    2 dependant ComboBoxes for Same datasource

    Hi, I have the raw data (A2:AD400), and the column 'A' is 'Name' and column is 'Quarter'. I have made 2 combo boxes for 'Name' and 'Quarter' which is independent. My final result will be, when I choose the name from 'Name' dropdown list, it has to show the selected name columns. And If I...
Back
Top