-1

I'am triyng to make a table, where I put person names in the first column and citys in the first row. I am going to choice one person name and one city, I want to know how many of this certain name staying in this certain city. I would like to know if it's possible to make in excell or LibreOffice Calc (I preffer it, because I am on Ubuntu), choice one person name and city name and it return's me how many of them had in the table.

I'm sorry for my english. Thank's so much.

victorcd
  • 429
  • 2
  • 6
  • 17
  • in Excel just use the `=COUNTIF()` function, you'll also need to concatenate the name and city strings into a single string which you can do inside you formula using the `&` operator – Dan Sep 15 '16 at 23:10
  • Sorry, I am very newbie in excel, I am using for the first time. Can you give me a example? Where I use this expression? Thanks – victorcd Sep 15 '16 at 23:35
  • http://www.excel-easy.com/examples/two-way-lookup.html – Tim Williams Sep 15 '16 at 23:50

1 Answers1

0

You can use the find() function in excel

James Cluade
  • 11
  • 5