[ Date Index ]
[ Thread Index ]
[ <= Previous by date /
thread ]
[ Next by date /
thread => ]
Re: [LUG] Spreadsheet help
- To: list@xxxxxxxxxxxxx
- Subject: Re: [LUG] Spreadsheet help
- From: Pentiddy <pentiddy@xxxxxxxxxxxxxx>
- Date: Fri, 1 Jul 2022 10:44:52 +0100
- Content-language: en-GB
- Delivered-to: dclug@xxxxxxxxxxxxxxxxxxxxx
- Dkim-signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=dcglug.org.uk; s=1649667962; h=Sender:Content-Type:Reply-To:List-Subscribe: List-Help:List-Post:List-Unsubscribe:List-Id:Subject:In-Reply-To:From: References:To:MIME-Version:Date:Message-ID:Cc:Content-Transfer-Encoding: Content-ID:Content-Description:Resent-Date:Resent-From:Resent-Sender: Resent-To:Resent-Cc:Resent-Message-ID:List-Owner:List-Archive; bh=krCLvITU/N0szvCpjun3oNXAhwj5lQ4dss46TdvIM04=; b=HxToqNZPW/AfOL4YrhI6udfwGk egk9EoBXMBUuX8YZhsnx/rd62dCsI87Wd75FRbY8JuBoMZTps1/RXIWy62qHIlzH3KOAjuEFJxOn3 FPKfM4n5nBEricjo0AZYQzzkPePWM08MD6rSdaR0OQaunDrS8/xWqL4Qun78gXs1hu7s=;
To add more detail to see if anyone can help:
an example of the data;
X
|
Y
|
Name
|
Status
|
08
|
07
|
Geoff
|
Booked
|
06
|
02
|
Marion
|
Provisional
|
10
|
10
|
Ferdinand
|
Awaiting payment
|
02
|
05
|
Sally
|
Booked
|
And then the 'map' would look something like ;
|
01
|
02
|
03
|
04
|
05
|
06
|
07
|
08
|
09
|
10
|
01
|
|
|
|
|
|
|
|
|
|
|
02
|
|
|
|
|
|
Provisional
|
|
|
|
|
03
|
|
|
|
|
|
|
|
|
|
|
04
|
|
|
|
|
|
|
|
|
|
|
05
|
|
Booked
|
|
|
|
|
|
|
|
|
06
|
|
|
|
|
|
|
|
|
|
|
07
|
|
|
|
|
|
|
|
Booked
|
|
|
08
|
|
|
|
|
|
|
|
|
|
|
09
|
|
|
|
|
|
|
|
|
|
|
10
|
|
|
|
|
|
|
|
|
|
Awaiting payment
|
I'm looking for the cells in the second 'sheet' to fill
automatically from the dataset in the first...
:-)
Thanks
Anthony
|
--
The Mailing List for the Devon & Cornwall LUG
https://mailman.dcglug.org.uk/listinfo/list
FAQ: https://www.dcglug.org.uk/faq/