My application has a large number of related look-up tables.

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

I have a spreadsheet with about 300 rows contining data on students. I
can mail merge this to print out reports but would like to make the

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


Ok, for the company I work for I have an excel sheet the contains data

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

Have a list of 1000 rows of data (countries). Use the adv filter unique to a
new region but still get duplicate values for US and a 'salesperson'. Tried

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


Hi,

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

I'm using the formula:
=IF(MATCH(C51,'Data Sheet'!A4:A103,1),quot;Added Holiday(s) For:quot;,quot;quot;)

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

I want my footer to say Damp;T, but instead it says D2:55PM. How do I turn off
the concatenating text?

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

I am using Autofilter in a spreadsheet and it automatically includes quot;Top 10quot;
as well as quot;Blanksquot; and quot;Non Blanksquot; in the drop down menus of each category.

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

I've checked the quot;gridlinesquot; boxes as instructed by the Help screens, but my
gridlines won't print. Any ideas?

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

is there a way to create a sum if statement with two criteria that sums a
different column. Sumproduct does not seem to work if there is an error #NA

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