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

    Need advice how to create data model where multiple columns combination

    Hi All, I am new to Power BI, Can anybody suggest me how to create data model for my specific scenario. I have below mentioned tables :- 1) Resource Plan : it contains details for all resources daily how much hours they have to fill domain wise. 2) Timesheet : it contains the data for all...
  2. R

    Custom Function required for multiple conditions

    Hi Chihiro, Thanks a lot for your valuable support to solve my issue. Its working fine now. Have a nice day to you. Regards, Rajender
  3. R

    Custom Function required for multiple conditions

    Hi Chihiro, Still the output is not correct , if there is no Zero in the row, its still showing output as last header row. In my last attachment uploaded here , I have updated the correct output file. Please assist. Regards, Rajender
  4. R

    Custom Function required for multiple conditions

    Hi Chihiro, Thanks for your help. I have checked the given formula , but its not showing the correct Header output. I have shown the correct output in column DX in attached file. Please suggest , where I need to do modification.
  5. R

    Custom Function required for multiple conditions

    Hi Chihiro, I found one formula nearest to my requirement could you help me out , what modification I need to require here :- Here its giving me the output and capture header of last non-zero cell. but I need here column header next to last non zero cell. =LOOKUP(2,1/(R2:CW2<>0),$R$1:$CW$1) I...
  6. R

    Custom Function required for multiple conditions

    Hi Chihiro, Well noted your comments, but actually this template is very old created by someone else and around 35 macros are taking references only from this template only. its very difficult for me to change the existing macros. because I have only knowledge of basic VBA macro of recording...
  7. R

    Custom Function required for multiple conditions

    Hi All, I have a Master Table Worksheet. I want to print message in Column DX "to be check" if below mentioned conditions matches. 1) RESOURCE STATUS = Should be ENGAGED/APPROVED. 2) ASSIGNMENT STATUS = Should be Blank 3) Now check for month from cell CW to R any value written as zero but the...
  8. R

    Macro for applying vlookup in multiple sheets from multiple workbooks

    Hi Nebu, I am getting file size is huge error here. I have uploaded all the file in below given link. http://1drv.ms/1GJqWNc Regards, Rajender
  9. R

    Macro for applying vlookup in multiple sheets from multiple workbooks

    Hi All, I have 1 master sheet in which I need to apply vlookup function in multiple sheets and from 3 different files(All files are located in same folder). Below are the headings for which I am applying vlookup function :- 3G 'TRANS_TYPEIP to IP Swap StatusIntervention DateIP to IP commentIP...
  10. R

    Rearranging the Data based on condition

    Hi All, I have raw data in below format around 20K to 30K rows and I need to rearrange the rows based on below mentioned condition :- 1) I need to filter on Ring name for example I filter Ring A05. 2) Then I filter 1 by 1 to ATN loop back column for example : I filter 10.35.201.1. 3)...
  11. R

    VBA Copy and paste column data in multiple rows for multiple conditions

    Hi All, I have worksheet where I have a below 2 main sheets :- 1) Code list : having example list of 1 codes which is required to copy for all the different IP's 2) IP list : for different criteria. currently I am taking example of 2 example :- 1) MW : First I go to code list and there in...
  12. R

    Copy folder from one location to another

    Hi All, I have found the below mentioned code by google to copy the files from a particular location to another :- But its showing error while I am changing the Frompath: to "https://abc.internal.abc.com/sites/Documents/N4S>" that path does not exists. Also when I am running same code in local...
  13. R

    Lookup values in 1 cell by comma seperated

    Hi Narayan, Sorry my mistake. you are correct misstype wrong reference. could you please assist for the same. I tried with recording macro but not successful because every time Main data sheet volumn of all the data with not same. In current file all data is of approx 11000 rows but it can be...
  14. R

    Lookup values in 1 cell by comma seperated

    Hi All, I have to return value in comma seperated(or "-" sign) in sheet 1 from range D3 :E last row. Criteria mentioned in G1 and I1. Example : In sheet 1 Header name 3G , and cell B3 which is 30537C1 in current case I will go to "All data" sheet column G and filter with same code :30537C1 and...
  15. R

    Chart Help

    Hi Srinidhi, For the time being I am adding the line chart by calculated item field. If is there any other workaround or chart type option. Thanks in advance for your valuable suggestions. Regards, Rajender
  16. R

    Advance Filter

    Hi All , Thanks a lot for valuable suggestions :-) Now I got my solutions. Regards, Rajender
  17. R

    Advance Filter

    ooops sorry. Now I uploaded image file. Regards, Rajender
  18. R

    Advance Filter

    Hi All, I have data sheet where I have following columns starting from Cell A1 to P1 Work Order_WO000 Dummy Project (PC)WO000 Type_WO000 Dummy LLC Upload DateUS000 Node 2GWO600 2G Line Swap/LL Avoided StatusWO600 2G Line Swap/LL Avoided ActualWO600 2G Line Swap/LL Avoided Upload DateUS000 Node...
  19. R

    Chart Help

    Hi Srinidhi, Thanks for your help. But unable to find the solution. IF any other way to show stacked chart with target line ? Or any VBA macro can provide the solution ? I tried via recording macro but not successful. Regards, Rajender
  20. R

    Chart Help

    Hi Narayank, I check once again the given link and found how its created. But in my case I need it should be dynamicaly updated which is equal to counta of column A and when I am trying the above formula its not working "=counta([ 'Work Order'])"
  21. R

    Chart Help

    Hi Narayank, I check but unable to clear how its made. Also check in google about steps to follow. I need a straight line in my current chart which needs to be equal of count of column A. and needs to be dynamically updated. I also tried formula in calculated item "=counta([ 'Work Order'])"...
  22. R

    Chart Help

    Hi All, I have 2 sheets :- 1) Sheet name "Final Sheet" : Raw data which is coming after running some calculation after a vba macro.(currently not attached other sheets). raw dump will always changes as soon as I will run macro a macro. 2) Sheet 2 name "Pivot" : this sheet contains the pivot...
  23. R

    Syntax field not highlighted if any sheet name contain "," sign

    Hi All, I learned a lot from this site and I applied many things useful tracker in my current work roll which is very much appreciated by my superiors. I am Thankful to all of you. Now I want to share I issue about excel. I always see the syntax wherever I am applying any formula. yesterday...
  24. R

    Formula to calculate pending week no. from defined cost

    Hi Narayan, Maximum weeks as per current data set I have is 52 weeks. Regards, Rajender
Back
Top