How do
I know if a Vlookup returns a value?
Select
cell B2, copy and paste formula =IF(ISNA(VLOOKUP(A2,$D$2:$D$185,1,FALSE)),
"No", "Yes") into the Formula Bar, then press the Enter
key. See screenshot: 2. Drag the Fill Handle down to the range you need
to vlookup and return yes or no.
Learn Excel
Formula's - https://exceljet.net/keyboard-shortcuts
Excel funtion to
truncate the column names to 29 characters + number if the name of the column
repeats
Macro to create
spaces in CamelCase names
<<Unity_Stage_Glossary_MACRO.xlsm>>
--Formula to rename
stage tables
=IF(EXACT(LEFT(F2),UPPER(LEFT(F2))),"BT_"&F2,"CT_"&F2)
how to get table
name from a string
=SUBSTITUTE(RIGHT(F2,LEN(F2)-3),"_Stg","")
how to match the
values of 2 cells (case sensitive)
=(EXACT(H2,I2))
How to Call a
Function in an Excel Cell
Overview - VBA in
Excel
CamelCase to
Snake_Case in Excel
Function
CheckKeyCodeName(inID As String, inRange As Range) As String
Dim vID As String
inRange.Select
Do Until
IsEmpty(ActiveCell)
If
InStr(ActiveCell.Value, "KEY") And InStr((ActiveCell.Offset(1,
0).Value), "CODE") And InStr((ActiveCell.Offset(1, 0).Value),
"NAME") Then
CheckKeyCodeName "True"
Else
ActiveCell.Offset(1, 0).Select
End If
ActiveCell.Offset(1,
0).Select
Loop
CheckKeyCodeName "False"
End Function
working with ranges
Copy Paste entire
row on a new row
Advanced Filters
Excel Formulaes - Cound Multiple Occurences of a cell in a
range
=COUNTIF($A$2:$A$1378,
$A1264)
Lookup the Multiple Occurrence
and get nth occurrence
Lookup bottom up in Excel
Explore Hlookup, Lookup, Array
Functions
https://exceljet.net/formula/get-nth-match-with-vlookup
Looping thru the
data
how to create new
rows in Excel
No comments:
Post a Comment