excel - Creating a formula to copy cells depending on adjacent cells -

-

i've got spreadsheet of company names , associated websites next of them. need create formula fill in missing website data correct data when website next company name.

for instance in screenshot below, value in b3 needs copied b2. same b7 b6. , b13 b12 , b11 , fourth.

some companies have no website @ if website present next last duplicate company name.

how create formula this? i'm not sure start don't mind creating new columns , moving data around , sorting etc. if necessary.

enter image description here

to deal company no web site start with:

copy column c values except when countif 1 (insert unique identifier instead, maybe ¬)

then (courtesy of @simoco):

select entire range data. press ctrl+g , select special.
choose blanks , press ok.
selected cells type = , press ↑ key. press ctrl+enter.
if want can copy result , make pastespecial-->paste values.

and finally:

replace ¬ nothing.


Comments

Post a Comment

Popular posts from this blog

java - Intellij Synchronizing output directories .. -

-
i trying build project, run in debug mode , keep getting "synchronizing output directories" in intellij. takes around 5-10 minutes actual build. project empty , stored on local drive. tried invalidate catche has not worked. out of ideas .. had similar issues? most likely, of data on network drive or in profile being synchronized network drive. if on windows, try moving .ideaxxx/system directory , work directory somewhere else on c: drive.
Read more

git - Initial Commit: "fatal: could not create leading directories of ..." -

-
i trying make initial commit git repository on github unity project. followed along this guide am. note: reason or another, couldn't set unity's asset serialization mode force text, settled on mixed (which believe should work). when call git clone --bare . , error. note not creator of repository , contributor (though making initial commit). here's in terminal (i'm using git bash): welcome git (version 1.8.4-preview20130916) run 'git git' display index. run 'git <command>' display specific commands. cheddar@cheddar-pc ~ $ cd documents/ics168swarch/ cheddar@cheddar-pc ~/documents/ics168swarch $ git init initialized empty git repository in c:/users/cheddar/documents/ics168swarch/.git / cheddar@cheddar-pc ~/documents/ics168swarch (master) $ git add . warning: lf replaced crlf in assets/prefabs.meta. file have original line endings in working directory. warning: lf replaced crlf in assets/prefabs/pellet.prefab.meta. file have original
Read more