Mynda Treacy said Ctrl+0 hides, but I thought the question is what shortcut unhides columns. I don't know of any shortcuts to unhide columns, but ...
Frans Visser said Nice one Clark! Not sure if it will work with all the times, but it's working fine for this one. If it is a recognized date and ...
Select one column, hold Ctrl and press 0 on the keyboard. If your office version is 2007 or above, you can try: hold Alt until some characters appe...
Please try the formula in attachment.
is this what you want?
Offset is more complicated. OFFSET(reference, rows, cols, [height], [width]) I will show you some examples. =OFFSET(A1,0,0) refers to cell A1...
Hi Mitul, The first table [ I will show you a simple example of Lookup function. Lookup value is 6 in cell K14, the table range is J18:K21. T...
MULTIPLE TABLES D2=VLOOKUP(C2,OFFSET(G$1:H$12,,LOOKUP(B2,{0,0;3,3;7,6;11,9})),2) Please have a try. Clark
Please try this one.
extract numbers first and then select column A:C, sort column B or column C in an ascending order.
Please attach your file in this post, I cannot open the link to your sample.
Please try this one.
please check the attachment, hope it is what you want. I deleted some numbers in column B which are not Date.
Hi Paul & connected the mathematical operators ">=" and the criteria. If the value in cell BG2 is 100, the two formula calculated as foll...
=COUNTIF(F2:BE2,">="&BG2)