1- I have a range like this: A1:A4 = {1;2;3;4}.
Use this formula: IF(A1:A4<4,1,""), return {1;1;1;""}.
Now I 'd like to replace "", to get: {1;1;1}.
2- I have A1=1; A2=2; C1=3; C2=4.
I'd like to have a range like this {1;2;3;4}.
For 1 and 2, Could you please assist me on which formula to use ?
Hi bebo021999
Kindly upload a sample workbook with your input data and reqired results for better understanding of your problem
In order to attach a file Click the Go Advanced button, and click on the Manage Attachments button
Azam
If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
For prompt answer, be descriptive, concise, short, direct, and to-the-point.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
bebo021999 
Register To Reply
Bookmarks