thx

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...

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...

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...

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...

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!

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

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

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!

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

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

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...

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

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.

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!

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

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

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

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...