Search results

Hi there, I would like to use formula =sumifs to sum the first 40 rows. Could you help me please. More in attachment Thanks

Hi guys, my excel file works really slow. Do you have some tips how to find that part (sheet) of file which causes it? Thanks

@gauravkrgautam Yes! I did. Once again thank you

@bobhc My excel file was complicated not that formula. Need to be write more understandable especially for u

Thank you guys so much. I thought it would not be possible. But the formula text(B4;"m.d") changed my mind It was kind of complicated but I modified the formula a bit and now it works very well

Doesn't work. It changes the value to 41518 File on link http://www45.zippyshare.com/v/9468715/file.html

Hi everyone, I need to change number from 1.9 to 1,9. When I have the value 1.9 excel takes it as the date 1.9.2013 because I have a Slovak version. I tried to simply replace "." to "," but when I did it I got the value 41518. I want to change a lot of these wrong values all at once.. could...

That's enough Smallman Thank you !

Hello, Can you help pls. In column A I have numbers. Column B consists of a lot of numbers as well. And I want to look up if number in A1, A2 ... is in B1:B500 array. If value in A1 is in B1:B500 array I want to see "yes" as an output

Perfect! Thank you Hui

Hi there, Is it possible to remove all the cells at the table at once? Final table should only consists of numbers. http://www50.zippyshare.com/v/43643456/file.html Thanks

Thank you so much NARAYANK991

Hello guys, Could you help me please? I attached the file http://www4.zippyshare.com/v/53510441/file.html In column A, column B, column C are data. In column called Result I wanna get one of the three words (BISTRO,CAS,CESTOVANIE) For instance in cell D2, if in the range A2:C2 is the word...

Thank you so much NARAYANK991! It was very nice of you

Sorry, those values in my source table are fixed. But I still don't get it. Basically I want to get that red color value (12,38 %) into my Pivot table (green color value). Because when I set the green value in my pivot table as the sum I get 72%, when I set the green value as average I get...

Sorry, haven't read that I created new topic thanks EDITED New topic: http://chandoo.org/forums/topic/pivot-table-7

Hello guys, i need your help with Pivot table. http://www63.zippyshare.com/v/85580632/file.html I uploaded a file and there is a Pivot table with products and their conversion. The last column is conversion (sell) rate that is calculated like sold / number of goods. It is just an example...

Hello guys, i need your help with Pivot table. http://www63.zippyshare.com/v/85580632/file.html I uploaded a file and there is a Pivot table with products and their conversion. The last column is conversion (sell) rate that is calculated like sold / number of goods. It is just an example...

Thank you for your help. I was just curious if it is possible to do that by changing a custom number format and then A2 + B2 = 12.9.2013 9:23

Hello everyone, COuld you help me with this issue? I have a date, lets say 17.7.2013 and countdown time 57 days 22 hours 13 minutes. And I want to sum these two cells and want to have the result like 28.9.2013 21:22 Is that even possible? Thanks in advance

Thank you guys!

Hello guys, I'm just curious how to change cell format. Imagine the number 2 163 244. And I would like to change the format to this result 2.1M Any advice please? Thanks

Now I understand. Perfect! Thank you for simple explaining .. My last question is where did you learn excel? Is there any advice, any guidebook ? Once again thanks all of you

To NARAYANK991: Perfect! Formula =ROW($M2)=MATCH($A$13&$B$13,$A$2:$A$10&$B$2:$B$10,0)+1 works fine, but another formula doesn't =AND($A2=$A$13,$B2=$B$13). I don't know to apply it To Debraj Roy: Well .. interesting formula. It works perfectly. Thanks you but what bothers me is the fact...

Hi guys Thank you very much I'm uploading the same file with notes. I hope after reading them you will understand me http://www61.zippyshare.com/v/77160234/file.html Thanks again