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

Recent content by shrivallabha

  1. shrivallabha

    need help regarding vlookup

    In cell D7, you can try following formula: =IFERROR(INDEX(DATA!$J$3:$AM$903,MATCH(ARREAR!$C$2&ARREAR!$B7,DATA!$C$3:$C$903&DATA!$B$3:$B$903,0),MATCH(ARREAR!D$6,DATA!$J$2:$AM$2,0)),"") which you can copy down and across. Note: You may have to use Array Entry (CTRL+SHIFT+ENTER) if you are using...
  2. shrivallabha

    Partial Matching

    Please see if the following formula does what you need: =IF(ISNUMBER(LOOKUP(99,SEARCH(" "&$A$2:$A$25&" "," "&D2&" ",1))),"Done","Not Proper")
  3. shrivallabha

    creation of Sub Folder and Super Sub Folders under Main Folder path

    I have tested and therefore commented. However, we probably are referring to two different approaches. Mine is mkdir through cmd and you are approaching through VBA. Following line through cmd works fine as I have mentioned! RetVal = Shell("cmd.exe /c mkdir " & Chr(34) & FldPath & Chr(34), 1)
  4. shrivallabha

    creation of Sub Folder and Super Sub Folders under Main Folder path

    If root directory is available and access is available to the user running the command then MkDir doesn't require folder existence check. If the specified folder already exists then the command simply won't do anything and won't affect any existing data e.g. files or sub-directories which are...
  5. shrivallabha

    need help to formulate an excel formula to share the required output

    Formula based solution in column M, N and O. In principle, logic required is around generating a repeat number 7 times and then subtracting sequentially to show the dates in the week. Note: This is fairly old approach. There may be nifty O365 functions which can do this in a shorter way.
  6. shrivallabha

    share excel file that contains a table

    It is possible to share if the file is on Cloud or SharePoint site even if it has Table(s). Examples would be: > Keeping it on OneDrive and sharing the file link. > Keeping it on MS Teams and sharing via Team >> Files option. You can see updates almost at real time. However, it also will...
  7. shrivallabha

    need a macro that will remove unwanted spaces for there is a space of 1 between each word. (will do for the whole sheet)

    Here's a code link which should do what you need! https://www.mrexcel.com/board/threads/trim-using-macro.638331/page-2#post-3168486 If you are looking for shorter version of code instead then: https://www.mrexcel.com/board/threads/trim-cells-help-needed.809781/post-3957874
  8. shrivallabha

    Average if with grouping

    Another option you can try is SUBTOTAL through outline. 1. Select Range for which you need SUBTOTAL (AVERAGE) 2. Choose Data >> Outline >> Subtotal 3. Choose settings as below 4. Output will appear as below. Excel will insert required rows. Bold ones in the snapshot below.
  9. shrivallabha

    Is there any method to write the formula quick?

    1. Create standard templates where possible with formulas so that you can enter only the changing / update part. 2. If you need to present summary then look at pivot table. 3. If you mean formulas that calculate faster than the ones you are currently using then post your data ask forum experts...
  10. shrivallabha

    New to Chandoo and learning - but can't find some options

    Can you give typical example(s) of "cannot find some of the items"? Maybe then people would be able to guess the probable reason.
  11. shrivallabha

    Custom number formatting - showing decimal point only when present

    @DashboardNovice : refer the orange cells in the uploaded file and confirm if that is what you want. Cell formatting has been set $ General
  12. shrivallabha

    Filter the names with consecutive numbers greater than or equal to 2

    If you have access to UNIQUE and FILTER functions then you can try (might be CTRL+SHIFT+ENTER depending on your version of Excel): =UNIQUE(FILTER(A3:A19,IF(A3:A19=A4:A20,IF(B3:B19>=2,IF(B3:B19=(B4:B20-1),TRUE,FALSE),FALSE),FALSE)))
  13. shrivallabha

    Return any customized text for the highest value in a column

    If you have access to TEXTJOIN function then you can try approach as provided in attached workbook. In cell I2, =TEXTJOIN("-",FALSE,C2:G2)&"_R"&H2 In cell J2 (which you can implement in A2)...
  14. shrivallabha

    Extract multiple numbers from string excel use formula

    With O365, you can also use TEXTJOIN and TRIM, MID (usual suspects in parsing) function like below. =TRIM(MID(SUBSTITUTE(" "&TRIM(TEXTJOIN("",TRUE,IF(ISNUMBER(MID($A4,SEQUENCE(LEN($A4)),1)+0),MID($A4,SEQUENCE(LEN($A4)),1)," ")))," ",REPT(" ",99)),99*COLUMNS($A$1:A1),99))
  15. shrivallabha

    Finding specific text using two lists

    I was about to post this link. Simple thing to note in this case is: the construct SEARCH produces a series of Numbers(greater than or equal to one) and Errors (#VALUE!)) which in turn gets converted to numbers less than 1 or #VALUE which get looked up by 2!
Back
Top