Thursday, March 30, 2023

Reverse vlookup , multi-condition sum

Reverse vlookup

 =INDEX(B:B,MATCH(TEXT(D9,"0"),D:D,0),0)

Text(xx,"0") convert number to text

MATCH(find_text,D:D,0) return index found

INDEX(B:B,index,0) return data follow index



Multi-condition sum

=SUMIFS(L:L,B:B,"FR",K:K,$B3)

SUMIFS(sum_column,condition1,find1,condition2,find2)

Tuesday, March 28, 2023

MOVE TABLE to new DB

 alter table my_old_db.mytable rename my_new_db.mytable


alter table boxcontrol.xbk_2023_03_24l0l08_49 rename backup.xbk_2023_03_24l0l08_49