Forum

Hans Hallebeek
@keebellah
Reputable Member
Joined: Oct 17, 2018
Topics: 8 / Replies: 365
Reply
RE: Compare two columns (A and B), in Column C, remove duplicated

Please reattach the file as a real attachment cannot download it as you have done now

3 years ago
Reply
RE: extracting specific payments from bank statement CSV

Hi Desi, I do not know what your skill-level is with VBA but you could build user defined functions that read the csv file and fill the table. You wi...

3 years ago
Reply
RE: Needs to return every first and third Wednesday of each month and every second and fourth Monday of each month on a board cast Calendar

Applying my NDOW macro and some own inventivity .... this is the maco version. You can always translate the macro into a formula if you do not want t...

3 years ago
Reply
RE: Needs to return every first and third Wednesday of each month and every second and fourth Monday of each month on a board cast Calendar

I found this code a long time ago and it works great ' We can generalize this to holidays that are defined as the Nth Day of some month, ' such as...

3 years ago
Reply
RE: COLOR UPDATE

Okay here are the two files you must check the formula, SUMIFS and not SUMIF I have attached the files with -2 in the name and added conditional form...

3 years ago
Reply
RE: COLOR UPDATE

Hi, wasn't able to connect earlier, picked-up the files and will take a look

3 years ago
Reply
RE: COLOR UPDATE

But you still haven't shown us what you want to achieve. Why not include a result of what you really want. You can do that manually and then we can s...

3 years ago
Reply
RE: COLOR UPDATE

The attachment failed the first time, here (I hope) it works

3 years ago
Reply
RE: COLOR UPDATE

Hi I added a column to your RECEIPTS file what looksup the new balance and shows the difference you can use that better that colouring

3 years ago
Reply
RE: How to create a summary page from data that is on the recipe pages only

Hi, took a quick look but your named ranges are inconsisten and need to be checked for incorrect references only then it can be done. There is a larg...

3 years ago
Forum
Reply
Reply
RE: Digitizing (Converting) a picture of graph to excel data

Interesting, I never did this but I did find this site How to Extract Data from Graph Image for Free? — PlotDigitizer Hope it helps you

3 years ago
Reply
RE: Find value where the middle 10 digits match other values in a column, then change those values.

Hi, sorry for the delay, ran into some issues with my system. Haven't forgotten you

3 years ago
Forum
Reply
RE: Find value where the middle 10 digits match other values in a column, then change those values.

Good morning, I'll take a look later today, see if I understand it and if I can help.

3 years ago
Forum
Page 24 / 25