Search results

Hi guys, is there any way to click on the cell which direct me to some tab where ill be image I want to show. It would be like: - click on cell B1 and after that the tab "Image" in the same excel file would open - in the tab "Image" is put my image Is it even possible Thank a lot

Thanks all of you. I know there is a lot of different solution by adding a new column etc .. I was just curious if it is possible to do it right into my pivot table. Probably not ... sad

Hello my friends, is it possible to count only those cells which have a value larger than 1? I'm talking about Pivot table and I would like to use calculate field for that issue. More in attachment Thanks a lot guys

Hi there, Could you help me out with my issue? I switched from Microsoft 2010 to 2013 version. After that my macros stopped working. There must be some issue with microsoft excel 2013 because when I had 2010 version my macros were working well. Thanks for your answer

Thanks for your help guys !

Sure I understand. I know this way but I'm asking if it is possible to do it right in to formula Thanks

If the result is 12 it should be 12. If the result is 123554 it should look like 123 554. It is tsd separator

Hi there, I want to ask you if it is possible to adjust my number format in formula. I have a simple formula =IF($B86=E$4;$C86;"") where the output is 1200. Is it possible to adjust my formula as the result will be 1 200. (with space -tausend separator) Thanks

So it is not gonna be that easy..

Hi there, I want to ask u if it is even possible to change color of the text in "" all at one. There is a file in attachment. I want it to look like the first row which means text in "" must be in red Thanks

I forgot to use trim function. There was a space Anyway, may I use vlookup function if the searched value is not in first column? It seems it does not work Thanks

Hello, is there some opportunity of using VLOOKUP function with text string. I want to lookup a text string Thanks

Thanks all of u @Debraj =SUBSTITUTE(B4,".","-")+0 this formula is very practical

Hi guys, could u help me with converting this 04.10.2013 08:00 to date&time format. Because 04.10.2013 08:00 is just text format and I need to convert it to date and time to work with it.

Hi SirJB7, Basically I don't need to change any cell format. I modified custom formating in graph - vertical axis

Hi guys, thank u so much for your advices. I finally managed it .... almost. I use this format [>=1000000]#,#0 " M";[>=1000]0 " K";0 " K" It shows numbers almost exactly as I wanted. Except "Zero" value shows like 0 K, which doesn't make any sence. It would be better to show Zero value...

Here's how it looks

Sorry Did not help to solve the issue

Hi everyone, how can I modify my custom number format to show negative number as well. Is it even possible to show these custom format numbers below zero [>=1000000]#,#0 " M";[>=1000]0 " K";0 Thanks

File with comments what I want to do is in attachment Hopefuly now it is more understandable

Hi guys, I want to find particular cell according to text by using formulas in all range. Lets say the cell called "CAR" That particular cell would be a reference point for another formula "OFFSET" Is this even possible? Thanks

Hi guys, I want to create a report. I want to fill data from more sheet by using formulas. There is a lot of data. An example with commentary what I want in attachment Thanks

Thanks guys for your help!

Hi guys, I work on my sheet. I want to print it with the header (picture). Everything's fine except the printing process. When I convert it to pdf or print, there is a gap up there between the border and header. (files in attachment) I know when I put it to microsoft word I can avoid this...

Incredibly simple! Thanks Narayank991