Re: Convert Text Number back to Text
Try custom format: m-yy and copy/paste values
Re: Convert Text Number back to Text
Try custom format: m-yy and copy/paste values
Re: Regular Expression in VBS
Hi, one way:
1. Insert data in a worksheet in B2
2. In A2 insert this formula: =IF(MID(B2,3,1)=".",0/0,"")
3. Fill down
4. Press F5, special, formulas, errors
5. Right click A2, delete, entire row
Re: fifo, macro, udf
Re: Comparing names without consideration to middle name
Alternative:
=IF(LEFT(A1,FIND(" ",A1)-1)&RIGHT(A1,FIND(" ",A1))=LEFT(B1,FIND(" ",B1)-1)&RIGHT(B1,FIND(" ",B1)),"X","")
Re: Lookup first value backwords
One way:
=LOOKUP(2,1/(A1:A8=3),B1:B8)
Re: Extracting 2nd Word from cell
Try
=TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",50)),50*1,50))
Instead of *1, can use *2 for second word, *3 for third word, etc.
Re: Sliding scale calculation
Re: Conditional Formatting Icons VBA code
Look here:
http://blog.contextures.com/archives/2009/…-in-excel-2003/
Re: Formula to return list of values that match specified values with NO DUPLICATES
Maybe:
http://www.get-digital-help.com/2011/05/13/vlo…alues-in-excel/
Re: write formula in all worksheet in a workbook
Try this:
Sub AllBut2()
For Each Sh In Sheets
If Sh.Name <> "1" And Sh.Name <> "Sheet1" Then
Sh.Range("D2:D5").FormulaR1C1 = "=RC[-2]*RC[-1]"
Sh.Range("G2:G5").FormulaR1C1 = "=RC[-2]*RC[-1]"
Sh.Range("H2:H5").FormulaR1C1 = "=RC[-6]-RC[-3]"
Sh.Range("I2:I5").FormulaR1C1 = "=RC[-5]-RC[-2]"
Sh.Range("J2:J5").FormulaR1C1 = "=RC[-1]/RC[-2]"
End If
Next
End Sub
Display More
Re: write formula in all worksheet in a workbook
Something like this:
Sub Macro1()
Sheets(Array("ALBK", "ABB")).Select
For Each Sh In Windows(1).SelectedSheets
Sh.Range("D2:D5").FormulaR1C1 = "=RC[-2]*RC[-1]"
Sh.Range("G2:G5").FormulaR1C1 = "=RC[-2]*RC[-1]"
Sh.Range("H2:H5").FormulaR1C1 = "=RC[-6]-RC[-3]"
Sh.Range("I2:I5").FormulaR1C1 = "=RC[-5]-RC[-2]"
Sh.Range("J2:J5").FormulaR1C1 = "=RC[-1]/RC[-2]"
Next Sh
Sheets("ALBK").Select
End Sub
Display More
Code partially created by the macro recorder and manually edited.
Re: convert and calculate time entered with period "." as separator (help)
Option:
http://www.exceltip.com/st/Change_slas…t_Excel/77.html
Re: Copy data from many worksheets-workbooks into single worksheet macro
Maybe this can help:
http://excel.tips.net/T002409_Mergin…=Jggyhfn3fHsx4X