samedi 9 mai 2020

How to add text between two or more results when using =filter()?

=IF(A6="","",IFERROR(FILTER($B$2:$B$4&$C$2:$C$4,$A$2:$A$4=A6))) 


returns JOB8000 vs JOB $8000.

VIEW IMAGE

Aucun commentaire:

Enregistrer un commentaire