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

    Issue with Cell fomat

    Hi vletm, i use the sample file to extract data from Database. the excel file is the input file and it will extract data from multiple table in Microsoft database.
  2. M

    Issue with Cell fomat

    Hi Vletm, Where do You get 'Data type mismatch'? - after running database. in the below screenshot you can se D2 cell is saved as text with ' but on the format cells window its in "General" format, C2 cell returns true for formula =istext(D2). select Error Checkin Options... and do wanted...
  3. M

    Issue with Cell fomat

    Hi, In the attached file i have 2 column with reference 1 and reference 2 which should be in Text format and used to extract data from Microsoft office database. issue is i have to copy data from multiple excel files(Various version xls, xlsx and macro enabled) and save in excel 97-2003...
  4. M

    Moving data based on Cell value

    Thanks Marc L for the Code
  5. M

    Moving data based on Cell value

    Hi All, Can you help with the attached macro. Trying to move data based on column C to the respective sheet. i have tried below code but its not working. need to move data for 10+ sheets
  6. M

    Macro to validate data and summarize results.

    Hi, Can you help with Macro for the Attached Spread sheet. For Sheet Trans1 and Trans 2 on Column S i have IF condition for 7 different cells and values which returns results after checking all the 7 conditions with Sheet Main i need the results of Trans1 and Trans2 against Gnum i have used...
  7. M

    comparing sheets

    Hi Team, i have need to compare two sheet and identify the new item and deleted item using the below formula on column C on respective Sheets Can you help me with the macro with the Formula and Copy the line Respective Sheets. Sheet 1 - Rows with Value "New Item" to New item Sheet Sheet 2 -...
  8. M

    to check sequence numbers

    Hi All, i got the desired results if the range contains data, however incase of empty cell its not giving me the results. Can you help on the below. Products Size 1 Size 2 Size 3 Size 4 Size 5 Results AAA 1 3 5 Not in Sequence BBB 15 22 45 54 60 In Sequence CCC 10 8 45 Not in...
  9. M

    to check sequence numbers

    Thanks Marc,Peter and bosco
  10. M

    to check sequence numbers

    Hi, Can you help me with formula for the below table. I have multiple user with 5 different sizes, I need to check if the sizes are higher for the next sizes in sequence if its higher it should give me result as “In Sequence” or “Not In sequence”. Products Size 1 Size 2 Size 3 Size 4 Size 5...
  11. M

    Extract data

    Hi Vletm, Thanks for your help
  12. M

    Extract data

    Hi Logit, it will be changing since it will be filled by different users and different department. what remains unique in all the files is m1 to m8
  13. M

    Extract data

    Hi Need help on extraction adjacent value of matching lookup value. In attached spreadsheet table A1:H13 contains data and not properly formatted has details On the same spread sheet I need to extract details for column m1 to m8 with value of next cell value from the table A1:H13
  14. M

    Dependent Drop Down List

    Hi Manish, Please find if the attached file is what you are looking for.
  15. M

    extract value based on primary number

    Hi All, Can you help with formula with the attached report? I have raw data with primary number, secondary number and shop, I need to convert the raw data input into output available on sheet 2. Thanks Mohan
  16. M

    formatting date

    Thanks Guido, the formula worked and able to get the correct date format
  17. M

    help to create macro for combined report

    Thanks Marc for the code, let me test and will get back to you incase of help
  18. M

    formatting date

    I use the MM/DD/YYYY format, all the dates is copied for Power bi table, tried changing the date format but not able to have same format for all the dates in B column
  19. M

    help to create macro for combined report

    ok for output workbook with no formula
  20. M

    formatting date

    Hi All, Requesting help convert the Column B date format (Wrong conversion of date) to column F. Tried changing date format highlight in yellow (Column J to M) using formulas, but still getting wrong conversion required your suggestion for date conversion
  21. M

    help to create macro for combined report

    As data will be last 3 months, I use 2019M+Month (05) to create helper column manually instead we use last digit on column B in output file to match and extract value from input file. I have modified the formula on column F in the output file
  22. M

    help to create macro for combined report

    Here attached the raw file with no helper column A and B. regarding the multiple year, the extract will be for last 3 months and it will be having multiple years
  23. M

    help to create macro for combined report

    Hi Marc, so Input2 workbook does not need any helper column (if ok Input2 columns A & B - at least B - could be deleted) --> added helper column for input2 as I get raw data which will start from column C to G, for second point its ok, to be deleted. Can you help me with...
  24. M

    help to create macro for combined report

    Hi All, Can you help me with combined report with two input file. Wanted to create macro to extract input file 1 and input file 2 to have one combined report comparing value against each store Input 1 – We have 5 column Input 2 – We need to add 2 helper column to have the same format month as...
  25. M

    Help required in formatting bar Chart on Excel.

    Hi Hui, Many thanks... Attachment with chart 1 is what I was looking for. Can you please help me steps to replicate. Mohan
Back
Top