I am trying to covert Julian dates to calendar date and am using the formula
=DATE(INT(A1/1000),1,MOD(A1,1000)). I am getting the date but the ytear

software 發表在 痞客邦 留言(0) 人氣()

I am trying to set up a spreadsheet and Need to put in the following function:

software 發表在 痞客邦 留言(0) 人氣()


I'm working on a spreadsheet that pulls data from separate sheets within

software 發表在 痞客邦 留言(0) 人氣()

I need to count the occurrence of a string that would be contained in text in a column.
For example, in column J, starting at cell 1,

software 發表在 痞客邦 留言(0) 人氣()

I am trying to use SUMIf with 2 conditions, I see someone else asked this
question before but I still can't get it to return anything other than #Value!

software 發表在 痞客邦 留言(0) 人氣()

I am doing a vlookup command and am it is only returning the first 255
characters. How can I make it return them all?

software 發表在 痞客邦 留言(0) 人氣()

I want to do a lookup using a list of sheet names in a workbook. For example
I want to lookup something in 'Sheet1' and refer to a cell.

software 發表在 痞客邦 留言(0) 人氣()


I am trying to create a formula for a percentage whereby the #DIV/0!

software 發表在 痞客邦 留言(0) 人氣()

blah blah blah blah blah

software 發表在 痞客邦 留言(0) 人氣()

How do I add several $ amounts using the same vlookup reference like quot;data?quot;
Is there a way to add a sum formula in the field?

software 發表在 痞客邦 留言(0) 人氣()