Question about Video Game Consoles & Games

1 Answer

EXCEL FORMULA Ello Peoples, If i had list of Names in column A and in column B a list of Items ( say Fred Red Ball Jeff Red Ball Fred Blue Ball Fred Red Ball ) A Formula to COUNT how many times Fred has a Red Ball.

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Champion:

    An expert who has answered 200 questions.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

  • Expert
  • 268 Answers

2 or 3

Posted on Apr 30, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

How do I set up excel to change the background of a cell as the information within the call changes?


Conditional formating should be able to this. But how is your data organized? (Column headers, Row headers etc.)

Oct 20, 2014 | Microsoft Excel for PC

1 Answer

Hi, I'm workin in Excel 2003 and I have column A that it has names (they could be repetitif names). Column B that it has dates (it could be repetitif dates but not for the same names in column A) and in...


I'm certain that I can solve your problem...

Can you send me a xls file with you data to my e-mail (pfjota@gmail.com) so that I can try with real data ?

Send these explanation with your email to !

Thanks

May 01, 2009 | Computers & Internet

1 Answer

Attendance list/ headcount spreadsheet


Don't do this in Excel. Buy Visual Foxpro.
And make proper application.

Apr 11, 2009 | Microsoft Excel for PC

1 Answer

Excel lookup - match index array


The best solution may be to re-define the named columns, or to add new names to multi-column arrays, then use the VLOOKUP function.
Note that the "indexed" named cells must be sorted by the index column.

Test (this is a 2 year old question)... Please ignore ths following. The plus symbol does not display.
Upper key plus symbol displays:
Right plus symbol on number pad displays:
[Shift] Right plus symbol on number pad displays:
[Alt] [4] [3] displays:
slash/slash/plus displays: //
slash/plus/slash displays: / /
Plus Plus Plus displays:
upper Plus Plus Plus displays:
Shift Right plus plus plus displays:

end of plus test.. thanks.

Dec 09, 2008 | Microsoft Excel for PC

1 Answer

Using NOW() in excel formula


That sounds like Excel. You may have to get someone locally to fix that problem.

Jun 10, 2008 | Microsoft Windows XP Professional

3 Answers

EXCEL FORMULA PC


The solution I've used in similar situations is to create a 3rd column C with the items in column A and column B concatenated.

C2 = A2 & B2
C3 = A3 & B3
C4 = A4 & B4
etc.

Then use COUNTIF function: =COUNTIF(C:C,"FredRed Ball")

Hope this helps.

May 27, 2008 | Microsoft Excel for PC

2 Answers

Excel Formula Help


Name the list as a range. Copy the list to a different location, eliminate duplicate values, then write the formula next to the newly listed items to count the number of occurrences in the original list range. Thanks for rating FixYa!

Apr 22, 2008 | Microsoft Office Professional 2007 Full...

2 Answers

Unsure of correct formula


You can add a reference from the worksheet 1 to all other worksheets

Is it OK?

Mar 08, 2008 | Microsoft Excel for PC

1 Answer

Lookup,s


If you can move your name column (C) to the first column, you could leverage the VLOOKUP formula pretty easily.
To do this, do the following:
1) Move the C Column to be the A Column, shifting all other columns to the right.
2) (optional) Insert a new row at the top of the sheet (to hold the formula & seach value)
3) Use A1 as your search field.
4) In A2, enter the following formula:
=VLOOKUP($A$1,$A$2:$C$6,3,)

Describing above parameters, in the formula:
$A$1 -> the search field (name your looking for).
$A$2:$C$6 -> The table/grid you wish to search and return values from. The left most column (A) must contain the values to be searched.
3 -> is the column number (A=1,B=2,C=3, etc) within the table/grid to return.

If you cannot make the name column your first (A) column, there are more complex ways to do this. For instance, create a new sheet which redisplays the info in the structure easier for this method, and perform the VLOOKUP on that data. Other options might exist in creating a complex formula that would get you what you want.
Also, if you can sort column A (names) it would find results faster, if your data set is large.

Feb 03, 2008 | Microsoft Excel for PC

1 Answer

EXCEL FORMULA


try using the formula "sumif". It allows you to sum by category/name. Good luck! D.

Sep 12, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Video Game Consoles & Games Logo

Related Topics:

101 people viewed this question

Ask a Question

Usually answered in minutes!

Top Video Game Consoles & Games Experts

Josh Whitehead
Josh Whitehead

Level 3 Expert

1148 Answers

yadayada
yadayada

Level 3 Expert

68038 Answers

Brad Brown

Level 3 Expert

14755 Answers

Are you a Video Game Console and Game Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...