Is there a formula to drag data listed in rows into a single column?
Is there a formula to drag data listed in rows into a single column? I would rather not copy and transpose paste all 2304 rates. I have a matrix of state to state rates in the contract-state...tab. The origin state is in ColumnA and the and the Destination state is in Row1 On Sheet1 I have the ST-ST set column A. I would like to have the rates populate in column B. to make vlookup easier.Help with If function
HI, I am trying to export relationships into a new database. I have to add the account number for each relationship type and there are many relationship types. There are more empty relationship types with no data than with actual data. I want it to say if the data in the relationship type (Company Relationships) is not empty then the relation account number should be the same. Can someone help me figure out why i have made this so difficult? I think I have it backwards but am not sure how to say if B2 is not blank or not empty. Thanks so much for your help. Mary Ellen =IF(B2<>"",C2=A2) Indiv Account Number Company Relationships Relationship Account Number 336 Minuteman Press FALSE 76 Kona Ice Midtown 494 enewton design 2574 2773
