Justin Doward's user avatar
Justin Doward's user avatar
Justin Doward's user avatar
Justin Doward
  • Member for 3 years, 11 months
  • Last seen more than a month ago
3 votes

Left trim: Remove characters after last instance of a number

2 votes

Split text at last instance of character (retain left hand side)

2 votes

multiply quantity by time - how do you calculate 15 times 30mins?

2 votes
Accepted

In Excel sheet I want to add semicolon to a cell that time format is HH MM SS

2 votes

IFS function in excel not able to work

2 votes

Ms Excel copy and paste data duplicate by x

2 votes

Specific cell to always have the same formatting, ignoring if new rows are created above

2 votes

How to define default program to open splitted xxx#. files and convert them to txt format

2 votes

Excel - Visual Basic issue

2 votes

How to create a column in Excel that tracks when data was input in a neighboring cell?

1 vote

Can I change the default match method in Excel from "Less than" to "Exact match"?

1 vote
Accepted

How to check duplicates value in columns

1 vote
Accepted

How to fill cells in the Excel with serie, range or similar?

1 vote
Accepted

Finding similar strings within two cells in excel

1 vote

What Excel function constructs and returns a reference to a range of cells?

1 vote

ExcelVB Programming Application

1 vote
Accepted

if function don't checks else if statement

1 vote
Accepted

How to conditionally concatenate a range with VBA?

1 vote
Accepted

showing error when use loop in vba

1 vote
Accepted

Excel: different number of digits in the same column Excel

1 vote
Accepted

Append & Remove values from multiple cells, convert resultant cell into Column

1 vote
Accepted

Excel bearing calculations

1 vote
Accepted

Compare two lists, for every match return value from adjacent column

1 vote

Display column header containing highest value in a spreadsheet

1 vote

Excel Macro - Hide and Unhide based on cell value

1 vote

Excel formula issue for entering "0" with empty cells

1 vote

I need to use an excel formula that takes a keyword in one column in order to extract full name of another column

1 vote
Accepted

Macro or VBA to select first empty cell in a column invoked from a pop up with 3 options, Macro 1, Macro 2 or cancel

1 vote
Accepted

Adapt existing VBA macro code to clear column, adjust row height and autofit column

1 vote
Accepted

Working with Excel 2016 and the length of an audio file eg, 0.004293981 = 0:06:11 (h:mm:ss)