BuzzJack
Entertainment Discussion

Welcome Guest ( Log In | Register | Help )

 
Reply to this topicStart new topic
> IF YOU ARE GOOD AT EXCEL HELP
Track this topic - Email this topic - Print this topic - Download this topic - Subscribe to this forum
mqh
post Dec 25 2016, 11:03 PM
Post #1
BuzzJack Platinum Member
******
Group: Moderator
Posts: 16,011
Member No.: 22,776
Joined: 19-December 15
   No Gallery Pics
 


Okay so, I have a spreadsheet, and I want to change the value of all cells containing only the value '10' to '1' to help calculate something chart related. I've tried formulas and everything, but I just can't quite figure out how I can change the value of cells from one value to another in bulk.

How do I do this?
Please help guys biggrin.gif


This post has been edited by CHRISTIANmas: Dec 25 2016, 11:04 PM
Go to the top of the page
 
+Quote Post
Liаm
post Dec 25 2016, 11:10 PM
Post #2
Balegdah
*******
Group: Entertainment Mod
Posts: 49,235
Member No.: 10,139
Joined: 7-December 09
 


Find and replace tongue.gif
Go to the top of the page
 
+Quote Post
mqh
post Dec 25 2016, 11:13 PM
Post #3
BuzzJack Platinum Member
******
Group: Moderator
Posts: 16,011
Member No.: 22,776
Joined: 19-December 15
   No Gallery Pics
 


QUOTE(Liаm @ Dec 25 2016, 11:10 PM) *
Find and replace tongue.gif

Jesus Christ I never even thought of that? ohmy.gif There was me typing in complicated formulas with commands and stuff :')
Go to the top of the page
 
+Quote Post
Steve201
post Dec 26 2016, 01:17 AM
Post #4
Shakin Stevens
******
Group: Members
Posts: 17,938
Member No.: 5,138
Joined: 29-December 07
   No Gallery Pics
 


Tell me to piss off if it's private but what chart related stuff?
Go to the top of the page
 
+Quote Post
Liаm
post Dec 26 2016, 01:21 AM
Post #5
Balegdah
*******
Group: Entertainment Mod
Posts: 49,235
Member No.: 10,139
Joined: 7-December 09
 


QUOTE(CHRISTIANmas @ Dec 25 2016, 11:13 PM) *
Jesus Christ I never even thought of that? ohmy.gif There was me typing in complicated formulas with commands and stuff :')

I always do that, once you know what you're doing stuff like this is much easier than you think! laugh.gif
Go to the top of the page
 
+Quote Post
Steve201
post Dec 26 2016, 01:26 AM
Post #6
Shakin Stevens
******
Group: Members
Posts: 17,938
Member No.: 5,138
Joined: 29-December 07
   No Gallery Pics
 


As Chris Tarrant said - It's only easy if you know the answer!!
Go to the top of the page
 
+Quote Post
JSG
post Dec 26 2016, 06:57 AM
Post #7
'Run Away With Me'
*******
Group: Members
Posts: 22,634
Member No.: 18,473
Joined: 18-March 13
 


I can't do excel. We've got a fancy excel program for the PC Multichart but that's as far as I go haha.
Go to the top of the page
 
+Quote Post
vidcapper
post Dec 26 2016, 07:30 AM
Post #8
Paul Hyett
******
Group: Members
Posts: 19,084
Member No.: 364
Joined: 4-April 06
   No Gallery Pics
 


QUOTE(CHRISTIANmas @ Dec 25 2016, 11:13 PM) *
Jesus Christ I never even thought of that? ohmy.gif There was me typing in complicated formulas with commands and stuff :')


You should see how complicated the ones I use to calculate YTD sales are! tongue.gif
Go to the top of the page
 
+Quote Post
Jonjo
post Dec 26 2016, 08:20 AM
Post #9
Together we are more.
********
Group: Artist Mod
Posts: 64,589
Member No.: 5,042
Joined: 13-December 07
 


Sounds like someone needs to hit up Kelly Rowland on Twitter or something.
Go to the top of the page
 
+Quote Post
danG
post Dec 26 2016, 11:10 AM
Post #10
putting the DAN (feat. Quavo) in dance music
*******
Group: Chart Mod
Posts: 40,397
Member No.: 11,746
Joined: 30-August 10
   No Gallery Pics
 




never forget!!
Go to the top of the page
 
+Quote Post
Mattias
post Dec 26 2016, 11:28 AM
Post #11
//
******
Group: Members
Posts: 10,934
Member No.: 7,132
Joined: 26-September 08
   No Gallery Pics
 


omg I'm laughing so hard at the Kelly Rowland thing.
Go to the top of the page
 
+Quote Post


Reply to this topicStart new topic

1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:


 

Lo-Fi Version Time is now: 27th June 2017 - 10:24 AM