hello I am a beginner I am trying to find the date closest to the day in a csv file and recover the associated value how can I proceed
here is a piece of my file
column A column B column C
date name value
Thank you for your help
Welcome.
Did You search ?
looking for the value that I managed to find with your link
but it is to find it from the nearest date that I am blocking
01/07/2021 marc 188431
08/01/2021 Julian 114,228.00
01/14/2021 eric 203764
01/14/2021 Julian 6189
01/15/2021 eric 953230
01/15/2021 marc 51714
01/21/2021 Julian 6198.2
01/22/2021 eric 101102
01/22/2021 marc 955165
01/29/2021 eric 207758
01/29/2021 Julian 207331
01/30/2021 marc 85624
02/05/2021 marc 6227
02/06/2021 eric 958102
02/06/2021 Julian 54141
02/12/2021 eric 570955
02/12/2021 Julian 6255
02/13/2021 marc 103046
02/20/2021 eric 213459
02/20/2021 Julian 194903
02/20/2021 marc 55383
according to the name and the date which approaches that of the day I want the value
exempe eric on 02/20/2021 ==> 213459
i know i ask a lot of you but i swim a little
thank you
This is your CSV return ?
01/07/2021, marc, 188431, 08/01/2021, Julian, 11422800, 01/14/2021 ,eric ,203764, 01/14/2021, Julian, 6189, 01/15/2021, eric, 953230, 01/15/2021, marc ,51714 ,01/21/2021, Julian, 6198.2 ,01/22/2021, eric ,101102 ,01/22/2021, marc ,955165 ,01/29/2021 ,eric, 207758, 01/29/2021, Julian ,207331 ,01/30/2021, marc, 85624 ,02/05/2021 ,marc ,6227, 02/06/2021, eric ,958102, 02/06/2021, Julian ,54141, 02/12/2021 ,eric, 570955, 02/12/2021, Julian, 6255, 02/13/2021, marc, 103046, 02/20/2021, eric ,213459 ,02/20/2021, Julian ,194903 ,02/20/2021, marc, 55383
Maybe ,
On the right side put your CSV and on the left a list variable.
So Your variable list ,maybe it has this format
(01/07/2021 marc 188431 08/01/2021 Julian 11422800 01/14/2021 eric 203764 01/14/2021 Julian 6189 01/15/2021 eric 953230 01/15/2021 marc 51714 01/21/2021 Julian 6198.2 01/22/2021 eric 101102 01/22/2021 marc 955165 01/29/2021 eric 207758 01/29/2021 Julian 207331 01/30/2021 marc 85624 02/05/2021 marc 6227 02/06/2021 eric 958102 02/06/2021 Julian 54141 02/12/2021 eric 570955 02/12/2021 Julian 6255 02/13/2021 marc 103046 02/20/2021 eric 213459 02/20/2021 Julian 194903 02/20/2021 marc 55383)
Each “word” is an element.
And each one has an index.
The names ( eric , marc , Julian ) are the index 2,4,6,8,10… right?
The dates are the (name index - 1) 1,3,5,7,9.
And the values are the (name index +1) 3,5,7,9,11.
Using For each Number from 2 - To Length Of List (your list), By 2
This Loop ( For Each Number Block ) will Go 2 by 2 looking for the name.
If found name ;
With Block Compare Text(red) ,+ Select List Item List Index(blue) = “eric”
If it´s Equals ,
With Block Compare Text if the index of name-1 is the same as the date you want.
If it´s Equals ?
If it is , take the index of the name+1 and show it ( value )