Czesc, Moj arkusz kalkulacyjny zawiera 2 arkusze (arkusz 1 i 2). W arkuszu1 sa kolumny data, id, komentarz. Glownym problemem sa rekordy z tym samym ID ale roznymi datami (po kilkanascie). Potrzebuje funkcji, ktora w arkuszu2 znalazlaby komentarz dla wskazanego ID z pozniejsza data (te wczesniejsze rekordy bylyby ignorowane). Jestem totalnie zielony, a moje proby pisania spalily na panewce, poniewaz caly czas wyskakuje mi blad !ARG. Z gory dziekuje za pomoc Smile
" data " , " id " , " komentarz "
" 02-01-10 " , " 1 " , " 1a "
" 02-02-10 " , " 2 " , " 2b "
" 02-03-10 " , " 3 " , " 3c "
" 02-04-10 " , " 4 " , " 4a "
" 02-05-10 " , " 5 " , " 5b "
" 02-06-10 " , " 6 " , " 6c "
" 02-07-10 " , " 7 " , " 7a "
" 02-08-10 " , " 8 " , " 8b "
" 02-09-10 " , " 9 " , " 9c "
" 02-10-10 " , " 10 " , " 10a "
" 02-02-11 " , " 1 " , " 1b "
" 02-03-11 " , " 2 " , " 2c "
" 02-04-11 " , " 3 " , " 3a "
" 02-05-11 " , " 4 " , " 4b "
" 02-06-11 " , " 5 " , " 5c "
" 02-07-11 " , " 6 " , " 6a "
" 02-08-11 " , " 7 " , " 7b "
" 02-09-11 " , " 8 " , " 8c "
" 02-10-11 " , " 9 " , " 9a "
" 10-12-12 " , " 10 " , " 10b "
" 10-13-12 " , " 1 " , " 1c "
" 10-14-12 " , " 2 " , " 2a "
" 10-15-12 " , " 3 " , " 3b "
" 10-16-12 " , " 4 " , " 4c "
" 10-17-12 " , " 5 " , " 5a "
" 10-18-12 " , " 6 " , " 6b "
" 10-19-12 " , " 7 " , " 7c "
" 10-20-12 " , " 8 " , " 8a "
" 10-21-12 " , " 9 " , " 9b "
" 10-22-12 " , " 10 " , " 10c "
" id " , " komentarz "
" 1 " ,,, " & lt; - w kolumnie komentarz chcia?bym mie? komentarz dla najstarszego ID z poprzedniej zakladki "
" 2 "
" 3 "
" 4 "
" 5 "
" 6 "
" 7 "
" 8 "
" 9 "
" 10 "