Search results

Hi Kanti, Thank you very much, you solved my problem :) I will check your formula and learn about it. Thank you

Hi All, I have a problem related with how to implement IF function in Time format data. So basically I want to compare if the Column M is less than 15 minutes, so it will show "Yes", but otherwise it show "No" I also attached the example file. Thank you

Is it possible to create automatically color (green for New and purple for Extend) bar, based on selected table?

Hi Hui, Thank you, I will read and try it first.

Hi All, I'm really curious how to create stacked column bar with different series value. I attached the image to make it easier for you to understand what I really want to achieve here. Really appreciate for any kind of help from you guys. Best Regards, AnggaRifandi

Really appreciate it Hui I never though of that way before :) Problem solved.

Dear All, I have problem when I want make this series number for Question ID in Excel. Question ID Answer 1 answer A 1 answer B 1 answer C 1 answer D 2 answer A 2 answer B 2 answer C 2...

@Chandoo It works. Really appreciate it Chandoo. Problem solved.

Hi all, I have question from my father about how to round up number in Excel. So my father have this number IDR 30,189,349 and want the result become IDR 30,189,000 because 349 is lower than 500. So if the number is IDR 30,189,500 the result should be IDR 30,190,000. Really appreciate any...

@Narayank991 Thanks, but the problem is I just want to put the image only behind the table, not for all cell.

Hi all, One of my student ask me how to insert background image behind the table in Excel 2010. Firstly, I think it's same with how to insert background image in Microsoft Word, insert picture and sent it to back, but unfortunately it doesn't work well in Excel. Anyone know how to do it...

Hi all, Thanks a lots friends. Your answers really help me. Now I'm become more excited to learn Excel here. @Narayank991 When we have to use array formula instead of regular formula?

@SirBJ7 Seem I have a wrong data, so the result is not appear. I have two question related with Vlookup() and string text. I posted the question here. https://docs.google.com/spreadsheet/ccc?key=0AhCF-jMpCuWJdFNsTVpxbnJyNm9hbmlzd1c5THhqcFE

Hi, Finally found this site, very helpful. I'm still beginner with Excel and hope by joining this forum, I can increase my knowledge about Excel and also make friends.

Hi, I have question about Vlookup() function. I want to show all data from my table using Vlookup, but the problem is the lookup value is text. So I want to show data from my table using ex. 0061 as the lookup value, so I try to use =vlookup("*"&E12&"*";A2:C6;3;0) but the result is #N/A...