Questions about excel-2010
Read more about excel-2010
python (12.9k questions)
javascript (9.2k questions)
reactjs (4.7k questions)
java (4.2k questions)
java (4.2k questions)
c# (3.5k questions)
c# (3.5k questions)
html (3.3k questions)
How To Separate Excel Data With Multiple Numbers In One Cell
I copied some data from a website and the data looks like this:
Is there any way to either separate the data or sum the three numbers in each cell?
John Rogerson
Votes: 0
Answers: 1
How can I convert GB and MB data string to GB(number) in Google sheet?
I have below data in string format
Size
670.2mb
668.4mb
3.2gb
1.1gb
479.7mb
I want to convert this column in below format
Sizw in GB Size in MB
0.6544 670.2
0.6527 668.2
3.2 ...
Sagar Vaghela
Votes: 0
Answers: 2
Copying a cell with certain cell color background
is there any code that allows me to copy several cells by the color of the cell background? So I have a recap sheet and the summary sheet containing detail of the data. I colorized the type of data in...
TheLSD
Votes: 0
Answers: 1
Excel - Replicating a SUMPRODUCT formula with already summed up values
I have a sheet that uses the below formula to arrive at a figure:
=SUMPRODUCT(E12:K12,E23:K23)/M10
To my understanding, it's getting the sum of E12:K12(593+622+636+620+595+583+589) and multiplying tha...
TomCrow
Votes: 0
Answers: 1