Replace cells and create dummy variables

**slacknoise** · 06-18-2012, 01:58 PM

Hi,

Once again i need help on an issue.

1. The cells containing a dot need to be replaced by zeros. This seems to be a problem as other cells containing numbers also contain dots.
2. Cells in column E, F and G refer to column A,B and C. Whenever there is no value in cells A,B and C i want to display a 0 for no value and a 1 for value in the respective Cells in column A,B and C respectivly. In this case F would refer to B and so on. (I did it manually to make my point clear in the file i uploaded)

If somebody could help me on this, that would be great. Thank you very much in advance. Attached find the file

**oeldere** · 06-18-2012, 02:03 PM

CTRL + H

find . (dot)

replace (zero)

and the formula in the yellow cells.

**jeffreybrown** · 06-18-2012, 02:12 PM

Highlight the range with the dots and run...

Please Login or Register  to view this content.

Now use this formula in E2 copied to the right and down.

=IF(A2>0,1,0)

**slacknoise** · 06-18-2012, 02:31 PM

this might sound stupid, but how do i "run" something?

**jeffreybrown** · 06-18-2012, 02:33 PM

This might help...

This is standard module code...

http://www.rondebruin.nl/code.htm

**oeldere** · 06-18-2012, 02:36 PM

Paste it in VBA an run the macro.

HOW TO INSTALL macro
you are new to macro, they are easy to install and use. To install it, simply press ALT+F11 to go into the VB editor and, once there, click Insert/Module on its menu bar, then copy/paste the above code into the code window that just opened up. That's it.... you are doneste in VBA is alt + f11

To start the macro you click on the button in the snelstartmenu of windows. (excel 2007) in my case the 8 icon.

Or you use alt + F8 en select the macro and select run.

**slacknoise** · 06-18-2012, 02:37 PM

Thank you very much. That helped a lot

**oeldere** · 06-18-2012, 02:40 PM

You help the forumhelpers if you add to whom you reply.

Replace cells and create dummy variables

LinkBack

Thread Tools

Rate This Thread

Display

Replace cells and create dummy variables

Re: Replace cells and create dummy variables

Re: Replace cells and create dummy variables

Re: Replace cells and create dummy variables

Re: Replace cells and create dummy variables

Re: Replace cells and create dummy variables

Re: Replace cells and create dummy variables

Re: Replace cells and create dummy variables

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions