[Solved] Search and index - then fill

me231 · Post by **me231** » Tue Apr 02, 2024 7:35 pm

way back - i used arrays to create an indexing for an expense sheet
the attached has a new sheet ( sheet 1) and the sample of the old on
Sheet 2 has a working index array setup .

the purpose
Given - spreadsheet with rows of entries
vendor, date, description, amounts etc

Result
create a column with requested / desired information

example from sheet one
given vendor
list all and associated amounts - or instances

my array formula is just too difficult to amend for each occasion -

is there a quicker easier way?

edit this topic's initial post · Post by **Villeroy** » Tue Apr 02, 2024 7:56 pm

This office suite comes with a database component.

me231 · Post by **me231** » Tue Apr 02, 2024 8:16 pm

ok- thanks will give it a try - may i bug ya for a small step by step - lessen learning curve?

me231 · Post by **me231** » Tue Apr 02, 2024 8:22 pm

java environment
? I think i need assitance using a wizard ....using 4.1.14

edit this topic's initial post · Post by **Villeroy** » Tue Apr 02, 2024 8:29 pm

Mac FAQ

me231 · Post by **me231** » Tue Apr 02, 2024 8:39 pm

under tools - there is no option to select java environment in my version? apologies but i need hand holding

edit this topic's initial post · Post by **Villeroy** » Tue Apr 02, 2024 8:47 pm

Forget the database.

me231 · Post by **me231** » Tue Apr 02, 2024 8:55 pm

thanks for MAc FAQ - got JAVA installed - is there a video for the power filter - how to use?

edit this topic's initial post · Post by **Villeroy** » Tue Apr 02, 2024 8:57 pm

Just open the database document and open the form(s).

[Solved] Search and index - then fill

[Solved] Search and index - then fill

Re: Search and index - then fill

Re: Search and index - then fill

Re: Search and index - then fill

Re: Search and index - then fill

Re: Search and index - then fill

Re: Search and index - then fill

Re: Search and index - then fill

Re: Search and index - then fill