MS Excel Formula, Charts, Pivot, etc

[jmeangeL]

Got questions about MS Excel or been trying to find ways to ease your daily report but not familiar with equations... post your questions here and we'll try and solve them 

[karxn]

I love MS Excel! There's always something new to learn.
Hopefully maraming mag-share dito na masters in Excel.

[solepurplelife]

Hi mga sis, I got excel problem. 

I need to copy the values of of the following.
Kelangan same values sa column B if same YMM

SAMPLE PROBLEM:
Column A (Year Make Model) |Column B (Bolt Pattern)

                     2003VolvoV70 | 5 x 4.08 in.
                     2003VolvoV70 |
                     2003VolvoV70 |
                   2003VolvoXC70 | 5 x 4.25 in.
                   2003VolvoXC70 |
                   2003VolvoXC90 | 5 x 4.25 in.
                   2003VolvoXC90 |
                   2003VolvoXC90 |

So dapat ang maging result is:

  2003VolvoV70 | 5 x 4.08 in.
  2003VolvoV70 | 5 x 4.08 in.
  2003VolvoV70 | 5 x 4.08 in.
2003VolvoXC70 | 5 x 4.25 in.
2003VolvoXC70 | 5 x 4.25 in.
2003VolvoXC90 | 5 x 4.25 in.
2003VolvoXC90 | 5 x 4.25 in.
2003VolvoXC90 | 5 x 4.25 in.


Last formula that I did na medyo close is =IF(A2=A1,B1,"")
Kaso kapos, parang ganito yung naging result:

  2003VolvoV70 | 5 x 4.08 in.
  2003VolvoV70 | 5 x 4.08 in.
  2003VolvoV70 |
2003VolvoXC70 | 5 x 4.25 in.
2003VolvoXC70 | 5 x 4.25 in.
2003VolvoXC90 | 5 x 4.25 in.
2003VolvoXC90 | 5 x 4.25 in.
2003VolvoXC90 |

Sana excel masters can help me. It'll be a big help talaga. 

[danda]

^sis VLOOKUP.

[solepurplelife]

oo nga noh sis.  Pinahirapan ko pa sarili ko haha. Thankyousomuch. 

[miss resilient]

ito ang bagay na hnding hindi ko matutunan

[Milada]

Huhu learned pivot and all settings sa MS excel all by myself -___- diko alam na i always need these things hahaha

[mommybunini]

used MS Excel everyday

[-munchkins12-]

I enjoy MS Excel. Great in manipulating data, numbers etc.

[_gigles_]

I cant imagine my life without Excel!!

[sarsingkit]

I love excel. Kahit nga text, sa excel ko na tinatype like mga minutes of the meeting.

[geecollection]

Hi mga sisses!

pahelp naman po oh.. how to do macro po.. need help po. thanks:)

[solepurplelife]

Basically sis macro comes handy when you do set of actions repeatedly. Two ways na magamit mo yung macro is through 1) Recording specific commands na ginawa mo (View Tab - Macro - Record Macro) tapos whenever gusto mo sya gamitin makikita mo lang sya sa View macros. 2) Macro Editor (ALT + F11) mas complicated na way. Pero if you are new sa paggamit ng Macro, mas okay na macro recorder ka muna.

[mommycute46]

Wishing for a 500 hundred rows of excel version. Or did I miss one? 2007 pa kasi gamit ko hahah

[sarsingkit]

^sis, practically infinite na ang rows ng excel sa 2007 and 2010. Parang 1M na ata. You mean column ba? Lagpas 500 din sa 2007 and 2010

[solepurplelife]

Ako rin 2007 gamit ko, and meron namang 1,048,576 rows and hanggang XFD col.

[mommycute46]

Ako rin 2007 gamit ko, and meron namang 1,048,576 rows and hanggang XFD col.

Ay 2003 pala sa akin (kuirpot mode lang si company ko). 65k rows and 256 columns in one sheet. SO I have to use several sheets because I'm dealing with more than 100k data. Imagine the long formula and the "calculating mode" I have to deal with 

[gummybearzz13]

I love using Excel din. Before ang gingawa ko lang eh manipulating formulas lang sa excel kaya yung billing namin sa clients namin mabilis na matapos kasi nagprovide ako ng template sa do's and dont's na din para sa mga iba pang gagamit. Ngayon nagdecide ako gumawa naman ng forms sa excel gamit ang visual basic.  learning pa din sa iba pang puwede kong gawin para sa msaccess naman.

[sima]

Mga sis, pa-help naman please.  Paano ko gagawin automatic fill ang cell pababa ng ganito ang format:

342-2104
343-2014
344-2014
345-2014
346-2014 and so on ....

ang nangyayari kasi pag dinadrag ko na pababa ang lumalabas ay ganito:

343-2014
343-2015
343-2016
343-2017

Thanks in advance!

[lulai]

sis, try to do this steps#
1. put your series first in a cell, say in A1 type 342
2. go to format cells > number > customs > then type #0"-2014", click ok
3. try the fill series - drag and right click > fill series

hope it works