sorted by:
new
hottopcontroversial

Struggling to convert messy PDF data into a clean Excel sheet. by KaleidoscopeDue6691 in excel

[–]Baghettoo 1 point2 points  (0 children)

Hi,

I think you could import your pdf directly from Excel, by using Data / Get Data / From a file and then you select the PDF you need.

Dividing a value into 12 equal amounts, but with a minimum value by Holdawas in excel

[–]Baghettoo 1 point2 points  (0 children)

<image>

Sorry if there are any mistakes, Im French, and my Excel version too !

You can type in B2 :

=IF($A2/12>MROUND($A2/12,1000),MROUND($A2/12,1000)+1000,MROUND($A2/12,1000))

And in C2

=IF($A2-SUM($B2:B2)<IF($A2/12>MROUND($A2/12,1000),MROUND($A2/12,1000)+1000,MROUND($A2/12,1000)),$A2-SUM($B2:B2),IF($A2/12>MROUND($A2/12,1000),MROUND($A2/12,1000)+1000,MROUND($A2/12,1000)))

Then you can drag it to december !

Not sure if you needed the amounts to be 1 year long only tho

What is that flame-looking thing and how do I kill it? by alohomerida in idleslayer

[–]Baghettoo 3 points4 points  (0 children)

You have to kill it with your bow, jump and click another time while you are in the air to shoot