Excel is very 2007
1 Like
And ChatGPT to boot.
Q for ye ladsā¦any usefulā¦freeā¦project management tools ā¦just want something basic to plan a project with timelines and assigned ownersā¦if it would automatically send reminders of deadlines etc be a bonusā¦
I suppose a Gantt chart in excel would be a good start
1 Like
Has a free option, might suit your needs. Used in companies Iāve worked with
2 Likes
If you have Office365 youāll have access to Planner. Itās pretty ok and reasonably flexible.
2 Likes
Open Project has a free version. Similar in style to MS Project
1 Like
Anybody out there with a pdf editor? None of the online ones will do what I want.
Itās a fairly simple task Iād say. The pdf I have, on some of the pages the text seems to be in white, so obviously canāt read it. You can search it and export it into Word but the format is fecked up.
So just a case of select all and change the text to black. A 5-10 minute job Iād say. I wouldnāt even need your email address. Iād just PM you a link for the file and you could email it back to me edited.
You know you want toā¦
I think you can do that with the Acrobat Reader. Itās an accessibility option.
(I donāt have an editor on the laptop where I am at the moment)
Perhaps with the new version with the advanced features theyāve been plugging lately. But not with the basic free model as far as I can make out.
Have you
Edit > Preferences > Accessibility ā¦
Nothing happens there, Thanks.
Iāve the man behind the wire on the job.
The sumifs formula worked but then I realised i needed to exclude certain values from Col P that were labelled CASH. Iāve tried adding
,P:P,āā<>CASHā',AD:AD but getting an error. I just added thos within the formula that already worked
Hard to see without your full formula but you should be correct. Assuming youāve got more either side of the bit you showed (and AD is the location of another set of criteria)
Your quotation marks look a little weird - you sure you put them in correctly?
1 Like
I put nothing else in to the formula already there as it already worked. Put a comma at the end of existing and added the above. Quote marks are correct on pc. Dodge on the phone.
Col AD holds all values.
If itās Sumifs then the values (AD) should be at the start. Only at the end for sumif (without the S for one condition).
1 Like
Thanks for that. Removed AD from the end and it worked.
1 Like
I ve a column of 10000 + cells
I filter the info I require and copy and paste into a another column but it wont copy over correctly as the filtered column has multipul ranges. How do I get around this?
Paste as value?
The 123 one here.
If you just use standard paste, you paste it as the field currently is (i.e. the formula)
If you paste as value, it just gives you the result of the formula. It sounds like you just want the value, not the formula
1 Like