thx

  1. S

    How to get the best of 3 choices according to the highest number?

    Can i check how do i get the final choices from this table to the second table? Employee Name Attendance Percentage Choice1 Choice2 Choice3 Alan 75.09333333 Project 1 Project 3 Project 4 John 73.37 Project 1 Project 4 Project 2 Alan 73.15 Project 3 Project 5 Project 6 Chris...
  2. O

    IF statement

    Hi, I have the following formula in an excel cell - =IF(S80<>"",(S80)+41,"") This puts a date in in the cell that is 41 days later than the entry in cell 80 if it isn't blank. What I would like to do is if cell Y80 has an entry then the target cell will be blank. I've tried to do 2 IF statements...
  3. C

    RE: Expressing Application.onTime("00:00:10") as a variable...

    RE: Expressing Application.onTime("00:00:10") as a variable... I just want to be able to vary the time to display a MsgBox using a variable from a cell value on a sheet using Application.onTime("h:m:s"), where h, m and t are variables In the title, a variable evaluates to 10 seconds. Would...
  4. K

    Sumifs

    hi i would like to know the formula for to consolidate data from Sheet 1. outcome should be as in sheet 2. <tbody> <colgroup><col><col span="6"></colgroup><tbody> Sheet 1 A B C A B C 01.01.2019 1 1 1 1 02.01.2019 1 1 1 1 03.01.2019 1 1 1 Sheet 2 A...
  5. S

    If function?

    Looking to have D1 look at C1 for a certain text such as 19-040S and fill in a date 8-May-19 in D1. I will have other options in C1 via drop down with different dates to fill in if selected. Just need the formula for 1 to start. Thx!
  6. L

    unique values

    Hi I'm heaving a small problem here my table looks like that 1 2 3 4 5 A X X Y Y Z B 12 21 10 10 10 I want to have unique numbers by letters in Raw C and D (like below) or in any other format C X X Y Z D 12 21 10 10 many thx in advance
  7. T

    One dropdown menu with checkboxes that allows multiple checkboxes to be selected, thank you

    Thx for stopping by my post. I'd be so appreciative if someone can tell me how to make a drop-down box (in one cell), where there's a checkbox before each selection, and most importantly, I can check off multiple items. thx for ur time and ur help
  8. E

    How to use number range in INDEX/MATCH?

    Hello! I am using Index/Match and in the value to be matched, I want to specify the value of a cell +/-5%. How do I specify that? thx!
  9. H

    text to date

    Hi, is there some formula to translate text stored like this "28. June 2018" into date? Thx
  10. K

    After fill in auto jump to other tab

    HI When i'm filling in the cells on tab "contact" it jump always to tab Offerte pp. i don't know how it is possible :-s THx kristof https://www.dropbox.com/s/1dtcank73s66z7k/CalculatorV2.1%20Komito%20Pool.xlsm?dl=0
  11. M

    Formula Help

    Hello ...... I have Cells A B C A & B will have numbers 1 thru 20......no zero's or negative numbers I need C to be 1 if criterias are met .......0 if not met Criteria: if A is 1........B can be anything.............C gets a 1 if A is 2........B must be >=7.................C gets a 1 if A...
  12. D

    Togglebutton as Option

    I have Excel Sht. Has Ribbon 6 Togglebuttons I need when Press ="True" One of then the other get opposite Press="False" Thx
  13. B

    VBA Get Elements About

    Hello, I want to get elements image src links from web to my excel sheet, For example link: https://www.ebay.com/rpp/sales-events-en/GEO-Favorite-Fashion-FS-ROW/for-her Can I get this link ? https://i.ebayimg.com/images/g/5zwAAOSw3ydVwx4e/s-l400/p.jpg http://prntscr.com/i24m4t Thx for helping.
  14. R

    Don´t want to update now().

    Hi Guys, in cell B1 is this statement =IF(E1="OK";NOW();""). The range for now() values will be in B1:B1000 and OK/NOK values will be in E1:E1000. But I need to have now() as a fixed value (non updating everytime I open the file). Thx in advance!
  15. P

    copy sheet to another workbook

    code for copy a sheet from a workbook(from another pc) in to sheet in to my pc workbook? thx
  16. M

    Ranking

    Hi i use rank on tab Calranking for the position , How can i get that ranking on may tab Ranking i try with v lookup but not working thx for help moose https://ufile.io/sirql
  17. P

    [VBA] reassigning a picture

    Hi I have two pictures, Picture 1 and Picture 2. I Need a macro that will allow me to assign picture from Picture 1 to Picture 2. If I use shapes with picture fill, I can use PickUp and Apply, yet, I'd rather use pictures. Is there a way to do something similar with pictures? Thx for help
  18. C

    selecting certain items in a pivot dropdonw in vba code

    hi, I am trying to find code that will select certain dates in a pivot table dropdown after it has been refreshed. The dropdown will have boxes for dates and the code should select all the months after today's date or between certain dates. thx. Using the macro recorder I have the following, but...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top