In A1 = 0
In A2 =IF(B2=***,quot;quot;,AVERAGE($A$1:A1)*2 1)

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

hi, can you help on my queries?
i want to use a single excel file as my database (for employee tenure

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

I would like to create a floating key that allows users to view a simple drop
down box that shows them what task they should be inputting on a worksheet.

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

I need to find a formula to return the address of the last cell in a column
that contains data. The location will always change as more data is added to

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


A B C D E

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

I have a vertically, names of peoples (20) and horizontally (15)
different objects. In each cell the total of objects for each person.

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

I am creating a script/questionaire that will be used by different people. I
would like to create a form (Excel?) where I could enter a question in one

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


Hi all,

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

I am creating a chart to compare values year over year. Ordering in the
worksheet reads Dec-Jan Left to Right. When I select the series in chart

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


What I am trying to do:

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