Search results

Would you like to use SUMIF instead. =SUMIF(E5:E70,"*"&"Room"&"*",F5:F70)

Hi Ramesh, Please see attachment, the code has been adopted from this link: http://investexcel.net/foreign-exchange-rate-function-in-excel/

Hi Kim, See if these two posts help: http://www.excelforum.com/excel-new-users-basics/737065-insert-live-exchange-rate.html http://www.wikihow.com/Create-a-Currency-Converter-With-Microsoft-Excel

Congratulations Sir! Keep going.. :)

Simply put your entire formula in another IF() like this: =IF(C5="",D15,YourFormula)

Hi Plz try this: =SUMPRODUCT(($C$7=ds!$F$8:$F$15)*('Output per Function'!$A12=ds!$A$8:$A$15)*('Output per Function'!$B12=ds!$B$8:$B$15)*('Output per Function'!C$20=ds!$G$7:$R$7)*(ds!$G$8:$R$15)) drag down and left [Edit: same as Narayan's solution :)]

@jeffreyweir, Most of the time as i present report to boss he is more interested in black and white lines and his required layout printed on a paper rather then SUMPRODUCT or INDEX MATCH or PIVOT TABLES behind them. If i try to explain him the difference in between them, he will ask me to keep...

Hi Nipendra.dhiman, You need to open the file with Open Office, most probably the password can be removed there.

Hi @rush2rajen Please see attached sheet.

I just edited post Index Match will also work.

Hi Sleepingboy Try: =SUMPRODUCT(($A$3:$A$4=P3)*($B$1:$N$1&$B$2:$N$2=$Q$1&$Q$2)*($B$3:$N$4)) ....drag down or for Index Match Case you should use this with CSE =INDEX($B$3:$N$4,MATCH(P3,$A$3:$A$4,0),MATCH($Q$1&$Q$2,$B$1:$N$1&$B$2:$N$2,0)) ...drag down.

Hi Deepak, HBD! Janam din ki shubh kamnain! :D

You need to do somewhat like this. Plz see attachment.

Hi, Please see this post. Consider adding a column with True in it, the code should work. http://www.ozgrid.com/forum/showthread.php?t=58648&p=302918#post302918

@Khalid NGO, You missed the Week 1 Criteria! :D =SUMIFS(Data!$E$2:$E$4,Data!$C$2:$C$4,Sheet1!B5,Data!$D$2:$D$4,Sheet1!A$1) @Nunes :p

You are always welcome. Please see attachment for 15 added rows.

Please try ROUNDUP(E15/50,0)*50 where E15 contains a number.

Do you want round up only round up/round down to nearest 50?

HI Mike, Simply join (concatenate) first and third column of your data using ampersand "&" and use conditional formatting to highlight duplicates.

Hi Brain, Plz see attachment, merged cells in your sample are problematic that led me to make a new file.

Hi Suzanne, Besides above suggestions you can try this but first consider backing up your data. If you think that your file size should have been smaller, then try this: 1. Open the sheet and press F5, on GO TO Menu, select last cell. this will select the last cell on the sheet. 2. from that...

Hi Molson, Please post a sample file. It will be helpful for others.

Hi Narayan, Oops, you are right! :P

Here is another workaround, if you are comfortable with R1C1 Style referencing. Enter 95 after C will take you to column # 95.

Hi Sarfarz, This link suggests a solution: http://blog.contextures.com/archives/2014/04/24/problems-pasting-in-an-excel-filtered-list/