Hi,
I have linked directly to a spreadsheet being used by a team that I then want to then work out some calculations on.
Simply (eg) cell A1 in their spreadsheet will be A1 in mine.
However, where there is a blank in their spreadsheet it's appearing in mine as 00-Jan-00 (or 00-01-1900 when filtering). Is there some simple way of linking the cells but not to carry across the blanks / make them appear as blank or zero even?
Many thanks,
B.
you are getting a zero returned and theformatting in your spreadsheet is set to a date
if you change to general it will display zero
BUT
i would use
=IF( cell in other spreadsheet!A1="", "", cell in other spreadsheet!A1)
so add the if and use the same formula
now you will get a blank if the other spreadsheet is a blank
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Wayne, that's worked, thanks! Have used your formula and it seems to work irrespective of what the value being linked is (ie. date, number etc).
Thank you.
your welcome and thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks