Search results

Luke M I know how to hide formulas but when I do that I'm not able to use merge and center function in excel. It happens to be blocked. That is the problem

Still not able to center and merge cells after hidden cell.

Hi chandoo, please is there any way how to hide formulas and keep all function in my excel? Since I hide formulas on all sheet I can not use all function like merge and center and many others. I just want to hide my formulas. Thanks for any response

Hui, I can not thank you enough. Really thanks a lot

Hi chandoo users, I do know how to use an hyperlink excel function. The thing is when I click on B4 cell I would like to switch the view to the cell $X$7. At least I think it should work like this. Am I right please? I just want to click on the cell then I want to switch the view to TODAY. Is...

Thanks a lot Somendra Misra I can not see the macro code though. When I moved the cell B7 it stopped working. Probably need to adjust the code

Hello everyone, I want to ask you her help. There is a long table consist of 53 weeks. If I want to see only week of 38 I have scroll lot more. And there is my question: Is there any way how to switch my view according the input. When I put number the number to B7 I want to see that week. More...

Thanks a lot guys, you helped me a lot!

Hello I'm just wondering if it is possible to filter my table according 1 team by formula. I made an example of NHL team. I would like to get a list of all (home/away) games of Anaheim Ducks. I can do this by formula but with useless blank rows (blue background). I would like to create a...

Thanks HAZ

Narayan you are perfect! Thanks for help

Hi, is it possible in excel to make multiple conditions by choosing the right value. I would like to choose one value from tab "B" to tab "A" according to condition from tab "B": - the highest price, in case there are two highest prices, choose that with less value of "Best before date" - in...

Thanks a lot mates ;)

Hi everyone, could you help me with this issue? What if I want to copy all maximum value from one table to another. Imagine I have a large table and I want to copy all maximum values with all the rest values (columns). There is a attachment as a example. Thanks for any help

@Somendra Misra Thank you Thank you all for help

Of course CF does work between two sheets

Hi, I would like to ask you for help. I want to set a conditional formating comparing 2 sheets. Sheet2 to Sheet1. I know It does work by adding row () to the formula, but only if I start from the cell A1. But I want to apply my conditional formating in a particular range C2:G13. Can you help me...

Perfect! Thank you so much Mike H.. Is there any great tutorial how to learn macros in excel? As i can see It can help a lot

Hi, please is there anybody to help me. I want to create 6 more excel sheets separately from the source table according to "Source" sheet, particularly Type value. Excel file in attachment. So I want to create 6 more sheets (reports) based on type column in the "Source" sheet. There are 2...

Speechless .... absolutely amazing. That's exactly what I wanted! Thank you so much Somendra Misra

August is enough Thanks

Yes that is right. I'm going to fill row 5 ... day by day. Today is 13th of august. And I want to compare sum of the same period of time. First of august till 13th of august comparing to 1st of July to 13th of July. Sum rows are 2 and 6 Thanks

Hi Somendra Misra, no, I expect to have my output in one cell. The output is the sum of A2:M2 in this case. But if i put another value to N5 then the output is the sum of A2:N2. regards

Hi there, please can you help me out with sumifs function? I attach an excel file. I want to sum row 2 according to how many values I have in row 5. I will be filling row 5 in the future so I want to automate it when I put another date in row 5 It calculates row 2 again. Thanks

Yeah that is simple. Thanks Faseeh ;)