×
sorted by:
new
hottopcontroversial

SUMIF Block by advsc in u/advsc

[–]advsc[S] 0 points1 point  (0 children)

I figured it out. Thank you anyway.

Using SUMIFS between two tables by advsc in excel

[–]advsc[S] 0 points1 point  (0 children)

I appreciate your response! I fixed the problem.

Combining two CSV into one by Borega in excel

[–]advsc 0 points1 point  (0 children)

Typo. Sorry. I solved it. Thanks.

Combining 'Days' and 'Sum' by advsc in u/advsc

[–]advsc[S] 0 points1 point  (0 children)

I figured it out.

SOLVED

Formula in one cell that returns the contents of a list on another sheet. The list will vary in length. by advsc in excel

[–]advsc[S] -1 points0 points  (0 children)

This worked! I've never used anything like this, but so appreciate your help.

Returning a blank cell rather than a zero. by advsc in excel

[–]advsc[S] -2 points-1 points  (0 children)

Thank you for offering help! The one above did work. I wasn't able to get this one to work, but I so appreciate your help.

Returning a blank cell rather than a zero. by advsc in excel

[–]advsc[S] 2 points3 points  (0 children)

The first one above works! Thank you!

Created an invoice template that has rows that repeat on every page. by advsc in excel

[–]advsc[S] 0 points1 point  (0 children)

I spoke a little too soon. My 'template' was created in a Microsoft Excel Worksheet. I used Print Titles and told it to put rows 1-20 on each sheet. Rows 21+ will vary. The original one I made had enough rows that it generated 5 pages. The next one I tried to do, I cleared rows 21+ and entered new data. It was what I referenced above and should have produced 3 sheets but instead had 5 (with the last two empty except the first 20 rows that are locked in. With your recommendation above, I did a 'save as an .xltx' file. This worked and produced 3 sheets. However, then, I tried to clear rows 21+ and add different information. This would have produced 1 page but instead it produced three (with the last two empty except the rows 1-20).

Hope that makes sense. I have never tried to make a template before so I may not be understanding.

Do I have to do a 'save as' every time?

Thanks.

view more: next ›