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

    ARRANGE DATA

    Thank u very much NARAYANK991, I want to cut the row name "income" and paste before the row name "external sector". Is there any formula to do this at once.
  2. salahuddin

    ARRANGE DATA

    I WANT TO ARRANGE THE ROW NAME "INCOME" IN COLUMN "B" BEFORE THE ROW NAMED "EXTERNAL SECTOR"
  3. salahuddin

    how do i paste data to visible cells only (without vba)

    Dear vletm thank u, thank u very much its working, i am very glad to see this. its help me very much.
  4. salahuddin

    how do i paste data to visible cells only (without vba)

    i have data in sheet 1 and i want it to paste sheet 2. sheet 1 have data c5: e244. and i want paste it to sheet 2 e:g filtered cell only. would u please help me to solve it. here is my demo file.
  5. salahuddin

    How to Un Hide Worksheet Tabs in Excel Workbook

    I have lock with password and hide a sheet of my work book. I lock the sheet using VBA option properties window and lock project for viewing. Would u please tell me how could i unlock the sheet for vewing.
  6. salahuddin

    Advance filter formula

    Dear sachar You can drag the data naming the cell as room/whatever u like. Paste the data to sheet ROOM using data validation. Paste the value of the data ie TK of ROOM data using same formula or using VLOOKUP. see the attach file
  7. salahuddin

    Paste data in filtered cell

    Dear NARAYANK991 Thank u for your response. I am very much tense about the matter. You right its row. In demo file, i want to copy the sheet2 cell C3 to C13 data and paste into sheet LOAN E1 to E62 without paste to filtered data. ie i want to pase to E2, E8, E14, E20, E26, E32 etc.
  8. salahuddin

    Advance filter formula

    please attach the sample file.
  9. salahuddin

    Paste data in filtered cell

    i have 2 sheet. in sheet A raw data have been filtered. i want to copy sheet B data to sheet A filtered data. But when i copy sheet B data and paste it into sheet A it paste to all column but not the filtered column.
  10. salahuddin

    PIVOT TABLE

    I'm not understand. by the by lets more clear the query. in the table "no' mean, no of loanee.
  11. salahuddin

    PIVOT TABLE

    HELLO ALL I have tried more and more but could not solve. Would u please help me to arrange the demo table for pivot table.
  12. salahuddin

    Using Powerpivot, create summary value of TopX?

    Dear Jason Koo just click on the pivot table and filter it as u want
  13. salahuddin

    PIVOT TABLE

    thank u very much chihiro
  14. salahuddin

    PIVOT TABLE

    Thank u PCosta87, if i rearrange the table like u, it needs thousand of row. it creates more than 12 thousand of row. i have 250+ row data like dhaka, khulna, barishal, sylhet, chittagong. i have 27+ column data like january, february i have 5+ column data like male, female etc
  15. salahuddin

    PIVOT TABLE

    Dear all is it possible to make pivot of the demo excel file. is there any way to present the info of the demo excel file. i have huge data of this type. But i could not make pivot of the file and present them. i want to make pivot of the file without using VBA. Please help me. salahuddin
  16. salahuddin

    Using Vlookup pull a live Hyperlink

    sorry!! typing the formula, it goes to the raw data page. i want to open the file which i search. in demo.xlsx, in sheet2 when i search something, i find the link in raw data in sheet1. in sheet1 the hyperlink found which i search in sheet2 and then clicking the cell in sheet1 i could open the...
  17. salahuddin

    Rank

    dear kim chanthan, simply filter the data. And set the condition of top three.
  18. salahuddin

    Hyper Link to Excel Tables

    hi Shay A, Can u upload the example file where u would want to apply the formula. salahuddin
  19. salahuddin

    Using Vlookup pull a live Hyperlink

    Typing the formula below =HYPERLINK("#'Sheet1'!M"&MATCH(VLOOKUP(A3,Sheet1!$I$6:$O$66,5,),Sheet1!$M$6:$M$66,0),VLOOKUP(A3,Sheet1!$I$6:$O$66,5,)) it goes to the cell where the hyperlink created. will it possible to directly open the hyperlink page
  20. salahuddin

    Using Vlookup pull a live Hyperlink

    dear Chiro many many thnks to u.
  21. salahuddin

    Using Vlookup pull a live Hyperlink

    IN SHEET I THE RAW DATA SHEET2 IN CELL A3 WHEN I TYPE THE DESPATCH NO OF LOAN CASE CELL B3 RETURN THE HYPERLINK OF SHEET 1 PLEASE SEE
  22. salahuddin

    copy Hyperlinks from a cell in 1st workbook to another cell in the 2nd workbook

    dear please help me to copy hyperlink using vlookup functioin
  23. salahuddin

    Using Vlookup pull a live Hyperlink

    Dear all Please help me find the formula to using vlookup to copy a live hyperlink
  24. salahuddin

    Hello .. Introduce yourself

    hi i am salahuddin from dhaka, bangladesh. want to smart in excel dashboard, power pivot, slicer and many more. i afraid to see the large most member of the site who update him/herself very fast. Does any one waiting for me??????????????? Any one here from dhaka????
Back
Top