Search results

Hi everyone, is there a way how to fix this. When I put this formula an error is occured. Problem is with this part of formula ... WEEKNUM($H$2:$H$5)=WEEKNUM(TODAY() .. Is there any way how to fix or do I only need helper column which calculate weeknum of those dates? Look to my excel file...

Hi Hui, this is not the first time when you helped me. Thanks a lot I really appreciate your help

Hello, i would like to ask you for help. I need to create very specific chart. In attached file is example of the chart I need with all comments. Could you help me please? Thanks for any help Post Moved by Mod

Thanks Narayan I Thought so. Condititional formatting won't help as well right?

Hello, please is it even possible to color only a part of text in a cell by formula? Let's say in a cell A1 is a text = partial text ==> partial(red color) text(green color) Thanks for any answer

Amazing solution !! Thanks a lot prasaddn

Hello everyone, I would like to ask you to help me solve my problem about Dependent Drop Down Lists. What I need is: Column B - selected values from drop down list from column H = no problem Column C - I want to choose products according to value in cell B2, B3, B4 ... I did it by marking...

Hi, I just want to ask you If there is any way how to reduce capacity of calculating proceses in excel. My excel file has 65 000 values in a column and I calculate with the formula like this...

Yes It is. It is not the first time when Narayank991 helped me a lot Thanks a lot

Hi Narayan, there is probably something wrong with excel file: <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error062560_02.xml</logFileName><summary>V sĂşbore C:\Users\janis\Downloads\chandoo...

That look's good but sometimes I need to background 3 rows upper, any other time 5 rows upper. Is it possible to background X rows upper according to value in cell D5. If I put there 5 I will background 5 more rows upper, if I put 3 in the cell D1 I will background 3 more rows upper .... Thanks...

Hi I would like to ask you if there is a way to background entire row if there is a value 16 in column B + 3 rows upper. So if the value of cell B12 is 16 all 12th row will be green background and 9th, 10th and 11th as well by using conditional formatting. Example file in attachment. Thanks for...

Thanks a lot Chihiro!!!

It looks like this Thanks a lot

Hi Chihiro, the thing is there is more column (5) connected to that particular date. In the example workbook is just one column connected to one date. Hope that helps Thanks

Hello, I would like to ask you for help. I need to get the results according to selected value (date range). Could you help me please? Excel file in attachment. Thanks a lot

Thanks Nebu, you showed me the way how to go on! Somendra Misra = excelent!!! Thanks a lot both of you

Thanks Nebu, it is close but does not fit required values. So basically, there are two conditions. These must match simultaneously (AND=) first condition = is "bluzky" in column A:A second condition = is there any occurence of "param1" in column B:B etc.

Excel file in attachment

Hi, is there any way how to use sumifs function with 2 conditions? First condition is easy, second one is about occurence text in string. I know there is a way to create a help column (ISNUMBER(FIND(.... ), but anyway is there any way how to do that using one formula? Excel file in attachment

I can not thank you enough for all your help Tiago MF and NARAYANK991. God bless you all

I forgot to mention that I would like to do that only by using formulas. Advanced filtering is not enough. Sorting might be there but it is not necessary.

Hi chandoo friends, I was just curious how to create an unique list of cells for all months I have. More in attachment. What I would like to get is in the yellow background. Thanks for any help

My issue is simple. If I hide formulas then I can not use my excel with all functionality (merge and center, pivot tables .. etc). I want to send my excel file with formulas hidden, but I want it to be all functional

Thanks bobhc, but let's forget the function merge and center. I absolutely agree with you. The bottom line is there is a lot more functions blocked if I hide my formulas. Therefore the question is Is there any better way how to hide my formulas? Thanks a lot