Today's formula =text(value, "yyyy-mm")

today we learned to format the date to see year and months only.  It was really simple. much easier than doing the concatenate formula
 to bring it out.

The transpose function is a gem.   I was stupidly doing it line by line without knowing that I would do it in batch.

Struggling

Still struggling with the government job. I just feel more stupid with each passing day. It is a waste of energy and mind or life in general. I just can't find a balance yet. I don't know why there has to be a union that would make sure the people least knowledgeable, progressive keep their job forever. That's so against my nature. But with the health issue in the way, i can't seem to get anywhere. But i don't want to sit and rot. My dilema.

Index vs. Match

Today I learned about Index (return value based on R and C location)  and Match (return the number based on the value provided.)

Then, I came up with this useless formua

=INDEX(Ben!A1:I1000,MATCH(VLOOKUP(A11,Ben!A:I,9,FALSE),Ben!I1:I1000,0),9)


I was trying to retrieve the value from another sheet, but wanted to retain the format.  Apparently, I need to write a macro for that.  It would be my next little project here.

Before the protesta.

Ok.