Give Mike a problem and he will deliver a perfect solution, really great !!! The PQ solution is my surely the best, but the formula the coolest solution. Thanks, Thumbs UP !!!
Can't express enough appreciation for how your solutions prompt us to attempt or own. Here is my own VBA solution: Sub StrComparison() For Each cell In Sheet1.Range("D1:D50") If Len(cell.Value) > 0 Then Length = Len(cell.Value) PosFromEnd = InStrRev(cell.Value, "-", -1, 1) - 1 NoLastDash = Mid(cell.Value, 1, PosFromEnd) FirstDash = InStr(1, NoLastDash, "-") + 1 FinalStr = Mid(NoLastDash, FirstDash, 50) Debug.Print Length, PosFromEnd, NoLastDash, FirstDash, FinalStr End If Next cell End Sub
Hi all your videos are so helpful. I have a problem that I cant get to grips with I want to sum amounts using the today's date only can you direct me to the best video to do this. Many thanks
hello, I have one problem, i wanna Subtract two cell .one cell(that show time for example 13:00)and other cell is current time(now() function) .and i wanna Subtract them.and then use if function and write: if the difference between two times(two cell)is less than 1 hour then do "this", how can I do that?anybody knows?
You don't need an extra cell for the current time, use the TODAY() function. A combination from the IF and the TODAY() functions will solve your problem. Google is your friend: www.ablebits.com/office-addins-blog/2014/11/26/if-function-excel/
Give Mike a problem and he will deliver a perfect solution, really great !!! The PQ solution is my surely the best, but the formula the coolest solution. Thanks, Thumbs UP !!!
Mike you are the "Formula King" !!! :)
Can't express enough appreciation for how your solutions prompt us to attempt or own. Here is my own VBA solution:
Sub StrComparison()
For Each cell In Sheet1.Range("D1:D50")
If Len(cell.Value) > 0 Then
Length = Len(cell.Value)
PosFromEnd = InStrRev(cell.Value, "-", -1, 1) - 1
NoLastDash = Mid(cell.Value, 1, PosFromEnd)
FirstDash = InStr(1, NoLastDash, "-") + 1
FinalStr = Mid(NoLastDash, FirstDash, 50)
Debug.Print Length, PosFromEnd, NoLastDash, FirstDash, FinalStr
End If
Next cell
End Sub
Mike você é o cara, quantas dicas, muito obrigado.
You are welcome for the tips!
Good Good Good.... was a good revision for how to use substitute and replace function....
Thanks
Glad it was good for you : )
Hi all your videos are so helpful. I have a problem that I cant get to grips with I want to
sum amounts using the today's date only can you direct me to the best video to do this. Many thanks
OMG! Awesome Intro!
Glad you like it! : )
В этот раз Вы превзошли сами себя!
Merci les gars ;-)
Thanks guys !!
You are welcome!
Thanks Mike
You are welcome, WRH!!!
What about a routine to move rows from sheet1 to different tabs based on cell(s) values?
Maybe VBA. Try posting here: mrexcel.com/forum
hello,
I have one problem,
i wanna Subtract two cell .one cell(that show time for example 13:00)and other cell is current time(now() function) .and i wanna Subtract them.and then use if function and write: if the difference between two times(two cell)is less than 1 hour then do "this", how can I do that?anybody knows?
You don't need an extra cell for the current time, use the TODAY() function.
A combination from the IF and the TODAY() functions will solve your problem.
Google is your friend: www.ablebits.com/office-addins-blog/2014/11/26/if-function-excel/
oh thanks, and by the way that was a great website,
why you use alt + enter in your formula !!
Just to add a line so that the formula was easier to read because it is not so long.
👍👍👍 :-))))
Thanks, Poet PQ : )