Formula error

MarkJoseph.Canada · 2025-05-06T22:33:20+00:00

There was an error rendering this rich post.

MarkJoseph.Canada

can you please check if you can assist?

“Basically, I have a formula RDP.Search("COMPANY", $B$8, "NBROWS:500 SORT:DTSubjectName:A", , ) which returns a sample

5073619959

5073620114

5073620117

5073619966

5074009689

5051175432

5084167849After I copy it and paste it back as values, I get 5073619959. all values after the first one are erased. I am unable to attach the file though. I can share it via email. This was already sent to FMC but was advised to check with dev team. Thanks!

Thanks!

Find more posts tagged with

excel

vba

#technology

#product

Accepted answers

All comments

Jirapongse

@MarkJoseph.Canada

Thank you for reaching out to us.

It is about the Excel formula (RDP.Search) so please contact the LSEG Workspace Excel dev or support team, not the developer forum.

The first line contains the RDP.Search formula. If the formula has been deleted and replaced, all values are gone.

You may use the following formula to display data in other cells (H1).

=RDP.Search("COMPANY", $B$8, "NBROWS:500 SORT:DTSubjectName:A", , H1)

EXPLORE OUR SITES