cell

I have cell (K7) to enter a value for hours I have cell (K11) to enter a value for minutes In cell K15, I want the outcome to be HH:MM in decimalised form - 7h:30m = 7.5h Sheet 2 is where I've linked the Vlookup to for the minute conversion, how can I join together the hour figure from K7 and...

Hi Guys I have 3 columns A2:C10 where i put an Id in ie 12345 now some cells could have blanks, an Id or multiple Ids separated by a comma what i want to be able to do is if the cell has an id or multiple ids then create a string like this <found> for some reason its lost my string concat it...

Hi All, I'm working on a spreadsheet that I would like to pick a random name from a list of 10 names using a vba button. the list of names are in cells C3:C12 and I would like the selected name to appear in cell D3 Thanks in advance.

In cell A I have a date (e. 22-Jan-16). In cell B I have a number (ie. 10). How do I make cell C return the cell A date plus the number in cell B in years? So it would return 22-Jan-26.

Hello everyone, Couldnt seem to find the correct formula for what I am trying to do. In Column O There will be a Yes or a No depending on Checkbox selection on userform. Say cell O2 is entered or changed to true then I want cell P2 to have a non changing date stamp. here is a screen shot of...

Good day all I need help with a MS Word form. I've searched all over the net and followed everything I've seen (I think) and I'm still stuck. I have a word table that I want people to fill out as a form. but I don't want the person to be able to change the forms layout. Specifically the height...

This would probably be a very simple question, but I can’tseem to get it right. What I need is a formula in a cell to say if this cell = a set of months i.e.January, April, July and so on then show this list of tasks and if the other monthsshow another set so example. =IF(C5=January,Feb,Mar)...

I have the following formula below =INDEX('C:\My Documents\[Comms2019.xlsm]Comms by month'!$A$11:$N$11,MATCH('C:\My Documents\[Comms2019.xlsm]Comms by month'!B1,'C:\My Documents\[Comms2019.xlsm]Comms by month'!$A$1:$M$1)) I would like to amend the formula to extract the year from cell P1 so...

Suppose I have several a range of cells, each cell of which contain a string, and I want a function to look at this range and output "FALSE" if all strings in the range are unique from each other and I want it to output the first duplicate it finds if there are at least two cells with the same...

I am am looping through a range on my computer (Excel 2013) and where I find a number 1 I want to replace it with a random number between the bottom number in Cell I9 and the top number in cell I11 So what I need my code to do is Activecell.value= "Randbetween Range ("I9").value and Range...

I am using Excel 2013 In cell L11 I have this formula Address (K11,7) This returns the address in the cell as $G$45 but the row number will change each time I loop the macro In my code I want to go to that address and continue running the code. to do this, I am using this code Application.Goto...

I apologize if this has been covered somewhere else, but I'm not even sure how to accurately search for my problem. I have a spreadsheet in which I have calculated a lot of data on 3 separate sheets. I'm trying to consolidate the data into a "Totals" sheet. I have used the following formula in...

Hi, I've used the following code in another workbook to open a calander pop up when I choose a particular cell and then once i've selected the date I want to select another cell. I'm trying to use the same code on another workbook however the cell I want to use to start the pop up is merged...

(Using both the latest Excel release (2019?) and libraries with legacy releases) I have some music track time lengths that are in the format 5:43 (h:mm), but another column displays 5:43:00 AM. So I used both the Format, Number, Custom, h:mm option on the cells that showed the AM designation...

Good Morning, I need to format a few different cells in the following manners: A1 has to always add a colon (:) after whatever is typed in by a user. Example- "F" in a cell becomes "F:" A2 has to always be three digits- so if a user puts in "1", the cell shows "001" or if a user puts in "20"...

Hello I'm looking for a macro that will copy cell contents of column E into Previous Row as it shows in this excel sheet in my google drive sheet. " From bottom Up check for column E if it find blank cell then copy that row into above row. E.g in this sheet in column E cell e15 is blank so the...

I have a workbook that gives me a number depending on cell color using Define Name. I named it GetColor. I used a previous post in MrExcel to do this. When I change the color, the number does not change automatically. What am I doing wrong? =GET.CELL(38,Sheet1!$B$2) This is what I am using...

I'm trying to do multiple text searches in a cell and return text if true. If not true then I want the cell to be blank. For example Column A is PaymentNotFound12345 and I want the formula in column B to search for "PaymentNot" and return "PaymentNot". However I need to also search for other...

Hello, I have a workbook with 120 tabs. Each tab has a different different name, but each tab has values in cells w12, x12, y12, z12, aa12 that i would like to get. Essentially I am trying to create a summary sheet that has the sheet names in column A and then the corresponding values. it...

I was wandering if there a way to have a hyperlink to a specific cell in a workbook? I email hyperlinks to excel workbooks thats on my network at work all the time but It would be nice if the link actually opened the workbook and went to a specific cell or row.