single

I have a cell that contains a count down to a specific time. The count down appears like this: 10d 23:18:43 Is it possible to write a formula that will convert the count down to hh:mm:ss? In the above i would expect: 263:18:43 Note that if a single day is left the cell looks as such: 1d...

Hi, Im wrangling a pivottable based off a single table. Its displayed in a tabular format. The table has property sale document number, price, sale date, buyer, seller, land description (e.g. Lot on Plan), certificate of title and I have got calculated fields for total area and, number of lots...

Hi all, I am working on a presentation & I want to show a number that decreases (like a counter) & after looking on some YouTube videos I think it could be achieved much easier with the VBA loop. However, I am having an issue with the below code where it will start with 10 (in presentation...

Are there formulas that will add, subtract, multiply, and/or divide data from two-digit numbers in a single cell? I appreciate any help I can get. Thank you in advance.

Hello, I was pointed in this direction by a colleague who told me if I needed an answer to an Excel question, then this was the place to be. So here I am :) I have a spreadsheet (Office 365). One of the worksheets is 99% protected - there are a couple of cells that the users can enter...

hi expert.. i need your help, how to combine this 2 argument in single argument : INDEX($L$2:$L$31;MATCH(A17;$K$2:$K$31;0)+IF(master!F2>0;0;IF(master!F2=0;2;1))) i want this below formula can be inserted in above formula =VLOOKUP(I2;master!$A$2:$O$5;6;FALSE) i have trying to combine it but...

So I have a basic Macro to select some data and create a chart - this works perfectly. The problem I have is that I need to create 78 of these charts. I am trying to get Excel to update the chart data for each estblishment based on a single reference cell that drive a host of VLOOKUP and...

I have a need to apply conditional formatting to a range of cells based on the value of a corresponding value in another range. I have managed to do this for a single cell, but can not figure out how to apply it to the range below is the formula that works on a single cell =$J$7<TODAY()-30...

I am looking for a way to add a comma after every single digit in a cell. I found some formulas on the web but since the number of digits is not equal in the cells, I can't get the result I need. For example, in column A: 12345 12 135789 135 etc. What formula can give me the result I...

Hi, I have a 60MB workbook that takes 8+ minutes to open on my quad core laptop. It opens only using a single core (20%cpu). After the workbook opens the first few adjustments I make causes the Excel to hang and takes a few seconds (3-5) to respond. After I save the initial edits it's faster...

Hello, Column "D" how I have codes with single and double digits, i want a VBA which can covert all single digit into 2 digits as per result column E Example file... Book1DE1234567891011Orignal CodeRequired Result126 | 4 | 4 + 10 | 0 | 0 - 0 | 0 | 106 | 04 | 04 + 10 | 00 | 00 - 00 | 00...

Hi all, How do I modify part of the below formula ‘Doors’!T:T to reference just one cell ‘Doors’!C4 If I change this reference to a single cell I geta #VALUE ! Error rather than the single cell value. =SUMIFS('Doors'! T:T,'Doors'!$B:$B,'Buildings'!$B42)*(1+$E$2+$G$2) Steve

Hi. Looking for guidance on how to use mousemove event on a multipage? Im trying to have a image as a button, and hover over changes colour. Below code works for a userform mousemove, but can find a solution when over a multipage instead Thanks Sub ExitButtonInactive_MouseMove(ByVal Button...

Const test1 As Single = numero + 500 Const test2 As Single = numero + 800 MsgBox (test1 = test2) It display "False" although test1 and test2 both are shown as "2,147484E+09" in Locals Window. How can I see the complete content of test1 and test2? (eg. in binary code)

I have a macro which allows me to allocate a random number between 1 and 100 between cells A3 and DV3. The random number selected is never repeated in row 3. The iteration is currently set to only 1 row but the macro currently allows me to add more rows by changing the iteration (I do not need...

I am looking for assistance with the following VBA code I have written to filter all data in my selected column to be applied to filter more than the single date that it’s giving. Sub SortDataWithHeader() ActiveSheet.Range("E1", Range("E1").End(xlDown)).AutoFilter Field:=5...

I am trying to reconcile a bank statement that has a single dollar amount and that dollar amount is made up of potentially 100 individual deposits. My list of single amounts is approx $116k and the amount that cleared is $106k Is there a macro that will test,in a loop fashion, the sum of...

Dear All, I have a large data set with 16,000 values. I need to extract the start date from the column. However, the dates are in different forms. Some have a single date wherein some contains ranges like 06-06-2019 - 08-06-2019. Is there a way wherein I can convert these into a single date...

Hi I have an excel sheet - the Data in the sheets are as - a single cell contains multiple lines of data - I wanna split the lines within the cell in to separate row - <tbody> Phil Ross Mc Lean David Ross Andrews Matthew Anders Sandra 21359877 25789563 4879652 2147631 24178965 email1 email2...

folks, i have a pivot table in which i wish to show the value of sales amount (calculated field) which, for each item, is the product of number of items sold and sale price. i have copied it to an adjacent part of the page to simplify the display for this post. also added the "should be" column...