Hello,
please is there any way how do I get rid of all TextBoxes in active sheet that are EMPTY via VBA?
There's a ton of them and my Excel got frozen.
Thank you for any help
Hello,
I'm from Slovakia and I use excel in Slovak language.
I have set some formulas and when It's open in Czech republic, an error has occured.
The formula just does not work at all.
Sheet name:
Error_sheet
Formula Cell:
G5
Formula:
=D5-SUM(((Table_3[Začiatok...
Hello,
I would like to ask you if there is any way to solve this:
There are 50 working groups in column C
Each work group is in a different color background in column C
Gantt chart is on right side with conditional formatting
I would like to apply the same color background in Gantt chart...
Hi everyone,
I would like to ask you if it is possible to show following in a chart:
Product:
Hour it takes to create:
Product A
80
Product B
50
Product C
120
One man daily capacity (this might change dynamically):
Daily capacity [Hour]
till 15.6.2019
15
till 30.6.2019
10...
Hi everyone,
I would like to ask you if it is possible to show following in a chart:
Product:
Hour it takes to create:
Product A
80
Product B
50
Product C
120
One man daily capacity (this might change dynamically):
Daily capacity [Hour]
till 15.6.2019
15
till 30.6.2019...
Hello,
is there any way how to extract decimal numbers with zeros?
Example:
Number: 1,6
=VALUE(MID(MOD(1,6;1);FIND(",";1,6)+1;2)) = 6
I want to get value 60
Is there any way how to get two decimal numbers please?
Thanks for any help
Hi,
please is there any way how to convert
number format (1 345)
to
currency format ($1 345)
by using a formula?
I tried this formula
=TEXT(B4,"[$$-C09]# ##0")
but finally it happened to be a text string.
Thanks for any help
Is there a way to convert string (equation) to equation able to be calculate.
Original format (column A):
22 y 180 d 5 h
Required format
8210,208333 (days)
Substitute formula helps a lot (column B).
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A9;" y ";"*365+");" d ";"+");" h";"/24")
But I'm still...
Hi everyone,
I would like to ask you if it is possible to do this:
According to date in column B (1.12.2016) I would like to get values from column C, merged to one cell separated by char(10).
More in attachment.
Thanks for any help
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...
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
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
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...
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...
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
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
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
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
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...
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...
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...
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...
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
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...