I have a large spreadsheet that I am linking data from to a smaller spreadsheet. I need a formula for the following: If cell is not blank, copy text from cell
Thanks
I have a large spreadsheet that I am linking data from to a smaller spreadsheet. I need a formula for the following: If cell is not blank, copy text from cell
Thanks
Something like:
Formula:Please Login or Register to view this content.
Change workbook name / sheet name / cell reference to suit.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Something like this:
=IF(Sheet1!A1="","",Sheet1!A1)
You may need to include the full path and filename if you are referring to different workbooks rather than different worksheets in the same workbook - the syntax would be something like:
'full_path[filename.xlsx]sheetname'!
instead of the Sheet1 that I have used above.
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks