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

    Calculate Data Based On Cell Color

    Hi Guys, Thanks for the replays. Allow me clear again, pls check the link here you find what i want to do. https://rapidshare.com/files/440943283/Data_calculate_based_on_cell_color.xlsx Thanks again.
  2. A

    Calculate Data Based On Cell Color

    Hi, Is it possible to calculate data based on cell color in excel? e.g: column A has multiple value with cell formatting (color). it’s depends on conditional formatting (color). There are 3 colors. Red, green, blue. I need to calculate the total amount of red color value and also other 2...
  3. A

    Unique Random Name

    Hello Chandoo, Thank..s.:-:)
  4. A

    Unique Random Name

    Hi, I try to get unique name from a list. the list is in A2:A10. and i want to get data in B2:B10. I try this: =INDEX($A2:$A10,RANDBETWEEN(1,COUNTA($A2:$A10)),1) on B2:B10. But the problem is it's take duplicate data from the list/range. i need each cell get unique random data from the list.
  5. A

    Is there a term for those who use Excel heavily?

    Hello.... what’s wrong!!! I think this is a forum for discus excel problem. Not for any other thing.
  6. A

    HAPPY NEW YEAR

    My dear friends, I know this is not a right place to do that kind thing. But I haven’t any other options. Because I don’t have the email id for the participants who comes here to solve/discus the problem on excel. I would like to special thanks to chandoo and his team to arrange this kind of...
  7. A

    Calculate Same Date

    Yes, I am looking for this. Thanks A lot both of you...........:)
  8. A

    Calculate Same Date

    Hui, Thanks for your support. And sorry for my miss communications. Finally I made this formula with your help. It is working but when L16 & G16 is blank then R16 show 1. I need to remove 1 when L&G16 is blank. I need there 0/blank cell. R16: =IF(O16=0.5,"0.5",IF(O16=1,(L16+1-G16)))
  9. A

    Calculate Same Date

    Hui, Thanks for your support. And sorry for my miss communications. Finally I made this formula with your help. 1st one is work perfectly but when I use 2nd formula then it’s show #NAME? (1st)R16: =IF(O16=0.5,"0.5",IF(O16=1,(L16+1-G16))) (2nd)R16: =IF(O16=Half,"0.5",IF(O16=Full,(L16+1-G16)))
  10. A

    Calculate Same Date

    Hui, thanks again. i found it's working for 1.5 day but i need 0.5 day.Would you pls see this link: http://rapidshare.com/files/439321803/test.xlsx
  11. A

    Calculate Same Date

    Hui, Thanks for quick reply. It’s working. Thanks :) But what about 0.5 day? Can you help me on that? How i calculate that is same cell?
  12. A

    Calculate Same Date

    I have 3 columns on one sheet. First one for starting date (A1), second one for ending date (B1) and last one for calculate the date/total (C1). It’s calculated date as normally and also need to calculate when date is same. And an option for calculate same date as half day. For ex: dd-mm-yy...
  13. A

    Entries in one template generating the second template

    Are you looking for this? i.e: for DRG NO column of 1st sheet in cell B4, and for 2nd sheet it is on C4. Now you want to copy the value from 1st to 2nd sheet in concern cell (B4 to C4).
  14. A

    Total Hour Calculation

    Thanks.....
  15. A

    Total Hour Calculation

    It's not working. 0:00
  16. A

    Total Hour Calculation

    =IF(B14="",B14,IF(B14>0,"10:00")) When b14 have any value >then 0 then in m14 show 10:00. And format cell is [hh]:mm. That formula on cell M14 to M44. The problem is that i need total hour on m46. I try sum, subtotal but it show 00:00 or wrong value. Thanks
  17. A

    Overtime calculation

    Thanks you both. :)
  18. A

    Overtime calculation

    xld, it is working. Thanks but i need to chk with b14. because i need when in b14 have value then k14 will calculate the over time. Hui, I think you got my question. I try your formula but it show ##### when g14 is 0.
  19. A

    Overtime calculation

    Hi, I want to calculate over time (working Hour) in excel 2007. My cell format is h:mm. and time format is 24h. I have 4 column for this: 1. Departure Time (D14) 2. Arrival Time (F14) 3. Travel Time (G14) 4. Over Time (K14) Standard working hour is 10 Hour. i need to calculate an worker...
  20. A

    Data Collect from another sheet!!

    Hui, Thanks A Lot..........:) It's working. Thanks for your support.
  21. A

    Data Collect from another sheet!!

    Hui, Yes i wants this. Thanks But when i changed CBN31 to CBN44/other in sheet3 cell B1 then it is show #N/A. it is unable to collect data for CBN44/other value. can you explain why it is show like this? or how i solved this? BTW, i am not expert on excel like you. so please help me to...
  22. A

    Data Collect from another sheet!!

    Hui, I all ready chk that file. but i need other thing. can you please chk my upload file? you can find there what i want to do. please see sheet3, i need all data from master sheet to sheet3 by clicking B1 cell. http://rapidshare.com/files/438493025/Link_Database_Mannaf__test_.xlsx Thanks
  23. A

    Data Collect from another sheet!!

    For ex: please download the link http://rapidshare.com/files/438493025/Link_Database_Mannaf__test_.xlsx
  24. A

    Data Collect from another sheet!!

    Hi, Sheet1 DATA: colA colB colC colD colE Switch Site_Name_AXB BCFID BTSID ETID CBN34 Mazu_Chudhurirhat 17 55 CBN33 Gondhorbapur 18 58 280 CBN31 Shakchar 19 61 281 CBN35 Shamsherabad 20 67 283 CBN35 Godown Road 21 70 284 CBN33 Mazupur 22 73 285,286 224 CBN33...
Back
Top