Search results

You have an number in Cell D18, if cell in cell D21 is empty cell E21 should be empty, if cell D21 has a value cell E21 should give de difference between D18 and D21. If positive in black if negative in red. See example.

Using Excel to create sticky notes , somebody an idea? You type an appontment in excel and an sticky note is created.

I have this formula: =VLOOKUP(H1;Info1!A:B;2;FALSE) So when I type a number in H1, the value should appear in columm B, next to the number. This is working for 1 worksheet, but I want it working for al worksheets. In my example, if I type 5 ,the word Praag Should appear next to Number 5.

In a worksheet, I have random unique digits in the range B4:G26. Now I want to display in the range B28:G50 the 10 largest digits from the range B4:G26. The other (smaller) digits should be converted to 0 or to an empty cell. Colors are just for the example Thanks

I have this formula =MAX(C2:C71) but i want combine it with an offset formula. In a cell i have this max formula, but in the cell above i want to add the the name that belongs to the max result, these names are in column B Thanks

Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Intersect(Target, Range("A1")) Is Nothing Then MsgBox "Maak eerst je keuze in cel A1", vbExclamation, "Cel A1 is leeg" End If End Sub

Case Is = 1 T_00.Value = WorksheetFunction.Max([Nr_1]) + 1 Case Is = 2 T_00.Value = WorksheetFunction.Max([Nr_2]) + 1 Case Is = 3 T_00.Value = WorksheetFunction.Max([Nr_3]) + 1 Case Is = 4 T_00.Value = WorksheetFunction.Max([Nr_4]) + ? Case Is = 5...

=IF(E1="C purchased" to =IF(E11Like"C purchased" How to change?

=IF(EXACT(A2,UPPER(A2)),"Upper Case",IF(EXACT(A2,LOWER(A2)),"Lower Case","Upper and Lower Case")) Now I get Upper Case when cell is empty.

See example I am looking for a formula that calculates the cost under 15.000 km at 0.018 and the difference above the 15.000 at 0.022 and make a total

See example

I have a result in a cell formated as uu:mm, for example 3:00, Then I need to add 3 times 10 minutes in another cell result should be 3:30 in a another cell. If the first cell is 2:30 then the result should be 2:55 (2 times 10 minutes and 1 time 5 minutes) The goal is when somebody works on a...

=IF(WEEKDAY(TODAY(),2)=6,TODAY()-1) IF(WEEKDAY(TODAY(),2)=7,TODAY()-2) I want to combine these 2 so that if it is weekend cell always returns last friday

Hi, I have this code to empty junkfolders in outlook. Unfortunately, it only works for the default account, what can I do to let it work for both accounts? Thanks. Sub EmptyDeletedItems() Dim olApp As Outlook.Application Dim olNS As Outlook.NameSpace Dim objExpl As Outlook.Explorer Dim mboxCount...

How can i change this code so it works for jpg and gif? If Dir(Path & Cell & ".jpg") <> "" Then With .Pictures.Insert(Path & Cell & ".jpg") Thanks in advance

When I fill date paid on in sheet 2 column B iwant to fill column I on sheet1 automatically with the dates. See example. Thanks in advance.

if the character is è or ì I would like these two characters change to windings. this in cells with more text ,the rest of the text should remain Arial

I have an excel query, but I only want the rows where the value in column 5 is less then the value in column 6 How can I set that criteria? Thanks.

I have 3 tables with different locations. With the names of the people that belong to these locations. In another table I want the locations next to the names See example

What would be the formula for: if column A range contains apples and pears then count column c that contains cancelled or pending Thanks in advance

I have this formula. =INDIRECT("Sheet" & COLUMN()-COLUMN($C$1)+1 & "!$A$1") But instead of the value I want the cell address. Thanks in advance

Hi, I am looking for code to solve my problem in attached example. I put the explanation in the file. Please advice Thanks in advance.

I have this formula: =IF(LEN(A1)=1,TEXT(A1,"0"),TEXT(A1,"0.00")) in CF How do I add the thousand separator. 4000 should be 4.000 10000 should be 10.000 4000,25 should be 4.000,25 10000,60 should 10.000,60 and if possible 10000,50 should be 10.000,50, not 10.000,5 Thanks in advance It can be a...

When i enter 1234567899, i want the cell changes automaticly into 12-34.-5678.-9\9 formula, vba Cell Properties, every solution is ok. thanks

I want to fill cell b2 with the text yes when Cell A2 is not empty, formula in cell A2 thanks to help.