I have a 7 sheet excel national d/base with the 4th sheet working out all the stats and therein lies the problem. Lots of links have been broken. Is there a person I can send it to?

Hi Jeovany

Would it be possible to cancel out the FALSE option in column 2 because as I understand it you cannot overwrite the word FALSE as we might like to use the column for adding some text.

Also, I guess I would be alright to add the odd extra line to some of the small tables in the Data Validation sheet.

We do need uncertain in the Sex tb and Paul is wanting extra Ages to be added and we might like to add the odd extra county in.

Thanks for everything.

Regards

Keith

Hi Jeovany

Yes, I can meet you at 7pm tomorrow on 24th.

Regards

Keith

Hi Jeovany

My boss Paul French would like to join in tomorrows Teams meeting at 7pm if that is alright by you.

His email is ******@bbrc.org.uk

Regards

Keith

Hi Keith

Let's meet tomorrow evening,

You are invited to a Microsoft Teams Meeting:

Meeting with Keith (MS Excel Forum)
24 April 2025
19:00 - 20:00 (GMT) London Time

Meeting link: Meeting with Keith (MS Excel Forum) | Microsoft Teams | Meet-up-Join

Regards

Jeovany

Hi Jeovany

Forgot to say that the zero's should answer one in the period column.

Also, when you entered the BTO Code in the species name does not alter (various sheets).

Will you be able to fill the species by year totals in the Species-Count sheet, which also had a column titled Birds to 1949, which listed all the records prior to 1950. Any chance that can be added ack in.

We will be tidying up the progress column and Ages sexes columns.

Last question: How did you manage to renumber all the records in the first column?

Regards

Keith

Hi Jeovany

Here is the link Archived Database-BBRC Power Query solution by JeovanyCV-OK.xlsx

Also, in the pre 1950 sheet under Period it is answering with a zero for all records in the 1800s. I know dates before 1900 are a problem. Also where is the table for the period with dates for each third of a month in 36 parts. Is it stored behind the scenes?

I have changed all the BTO codes and the Serial numbers for each species so they all should be correct across al sheets.

My boss does not seem to grasp that the Age and Sex columns and the Progress columns are the ones that need most attention.

With the Ages column I have just tried to edit (numbers) from the Age of the species but it is not recognising it and throwing up a host of error messages.

Thanks in anticipation.

Regards

Keith