|
|
Post by Philip Ayres on Feb 16, 2016 20:34:21 GMT
That's cool, but it would probably be clearer if the sold stuff was just removed. It was easier to see it when it was struck through. I couldn't figure a way of transferring the "strikethrough" formatting from my spreadsheet to the forum. You're right it is easier to read. I might do it manually myself though. -- Graham Easy. First column is your item and price Second column is a mark to indicate if it's sold Third column (for row 1 and then copied down) is thi formula =If(a1="","",if(b1="",a1,"[ s ]"&a1&"[ /s ]")) Copy that third column |
|
Deleted
Deleted Member
Posts: 0
|
Post by Deleted on Feb 16, 2016 20:57:34 GMT
I don't think such sorcery works for me as I don't use Excel. But thank you for your time, Phil.
-- Graham
|
|
|
|
Post by The Doctor on Feb 17, 2016 13:16:34 GMT
That is withcraft, Phil.
-Ralph
|
|
|
|
Post by Philip Ayres on Feb 17, 2016 13:22:12 GMT
Oh yes, you should see what I can make spreadsheets do.
I had to earn the money to pay for the TFs somehow and to do that I made excel bow before me!
The formula's simple:
If cell a1 is blank, then produce a blank cell.
If a1 isn't blank then look at cell b1.
If it is blank then make the cell equal to a1
If it isn't blank then make the cell equal to a1 with the strikethrough BB tags at either end.
Simple.
You should see the code that take a TFU link and turns it into a BB code link with the right name!
Or the stuff that turns excel into a BB code table
|
|
|
|
Post by Pinwig on Feb 17, 2016 13:43:04 GMT
Coincidentally I was teaching Year 8 pupils the If function in Excel last week. That was hard enough, but if I'd tried to explain to them that an If statement can also be used as a value inside another If statement their heads would have exploded, and so I think would mine.
|
|
|
|
Post by The Doctor on Feb 17, 2016 23:01:56 GMT
Excel makes my head spin.
-Ralph
|
|
|
|
Post by blueshift on Feb 18, 2016 13:18:57 GMT
What's that, Ralph? You want to learn array formulas?  |
|
Dezzeh
Thunderjet
Wait, what?
Posts: 4,887
|
Post by Dezzeh on Feb 18, 2016 13:45:50 GMT
The worst part about having to do desktop support for people is they expect you to know all the inner working of Excel.
I am so very happy when it finally dawns on them that none of us can tell them how to do anything that doesn't involve autosum
|
|
|
|
Post by Philip Ayres on Feb 18, 2016 16:26:31 GMT
I worked for actuaries
They used lots of excel
I was very popular
|
|
Dezzeh
Thunderjet
Wait, what?
Posts: 4,887
|
Post by Dezzeh on Feb 19, 2016 10:50:48 GMT
Though I feel learning Excel may be easier than todays task of convincing backupexec to stop being a pile of poo.
|
|
|
|
Post by The Doctor on Feb 21, 2016 20:58:20 GMT
What's that, Ralph? You want to learn array formulas? No! -Ralph |
|
|
|
Post by Pinwig on Feb 11, 2023 12:31:12 GMT
I may be compiling a list of ones I need. -Ralph I have 17 Marvel Epic Collection books. I have 12 Marvel Omnibus books. Must...have...more...make...a...plan... -Ralph I refuse, however, to do a spreadsheet. You must be introduced to the glory of sorting and filtering... |
|
|
|
Post by The Doctor on Feb 11, 2023 17:08:30 GMT
No effing way. We have spreadsheets at work and they are a nightmare for getting information.
-Ralph
|
|
|
|
Post by Andy Turnbull on Feb 11, 2023 17:27:35 GMT
Then they are poor spreadsheets.
|
|
|
|
Post by The Doctor on Feb 11, 2023 17:33:57 GMT
I can't abide spreadsheets. I hate them with every fibre of my being.
-Ralph
|
|
|
|
Post by Philip Ayres on Feb 11, 2023 17:38:07 GMT
Spreadsheets paid my salary, pay my health insurance and let me perform wonders beyond the dreams of mortal men. I will not have a word said against them.
Apart from Pivot tables. They're the work of the devil
|
|
|
|
Post by Grand Moff Muffin on Feb 11, 2023 18:13:49 GMT
The word spreadsheet makes me think of bedtime.
Martin
|
|
|
|
Post by Benn on Feb 11, 2023 19:43:38 GMT
Do we need a bedsheet spreadsheet?
|
|
|
|
Post by Grand Moff Muffin on Feb 11, 2023 19:48:08 GMT
Do we need a bedsheet spreadsheet? Or just a bedspreadsheet. Martin |
|
|
|
Post by Grand Moff Muffin on Feb 11, 2023 19:54:25 GMT
A Google search reveals you can actually buy spreadsheet bedsheets.
Martin
|
|
|
|
Post by Andy Turnbull on Feb 11, 2023 19:56:27 GMT
A Google search reveals you can actually buy spreadsheet bedsheets. Martin Phil will want a set. |
|
|
|
Post by Pinwig on Feb 12, 2023 11:03:48 GMT
|
|
|
|
Post by Fortmax2020 on Feb 12, 2023 23:50:37 GMT
I can't abide spreadsheets. I hate them with every fibre of my being. -Ralph But spreadsheets allow you to make pie charts. |
|
|
|
Post by Grand Moff Muffin on Feb 13, 2023 6:07:45 GMT
We were able to make pie charts before there were computers or spreadsheets.
Mmmm. You know what pie charts make me think of?
That's right.
Chartering a ship.
(To go in search of pies.)
Martin
|
|
|
|
Post by The Doctor on Feb 16, 2023 10:27:58 GMT
I am a regular listener of the fine MORE OR LESS radio programme. This week's episode is SPREADSHEET DISASTERS. www.bbc.co.uk/sounds/play/p0f2cytqSome amusing Excel mishaps relayed -Ralph |
|
|
|
Post by Bogatan on May 1, 2023 21:54:46 GMT
I have been using LibrOffice Calc to keep track of Toyfu stuff. A couple of years ago I badly cobbled together a formula to tally how much of Nicks money I had spent. It worked in that it did the maths, but required a manual adjustment every time. Tonight I worked out how to write it so it doesnt need adjusting.
This is basic stuff but spreadsheets have always baffled me so this is a big success for me.
|
|
|
|
Post by The Doctor on Nov 3, 2024 12:15:03 GMT
|
|
