Excel / Sheet help needed

[Reddox]

Hi,

For roleplay, I've been constructing a Criminal Record on Google Sheets.

Agents use a google form which response is sent to a google sheet.
I would need youre help with two things :

 

1- or statistics purpuses, i'm looking to run a command to know how many people were arrested in a zone. For now, I use "=NB.IF(E3:E502; ">=1000 ; <2000")" , of my database, but it doens't work.
 

2- To simplify their work, I would like to create a sheet where they enter a name, enter and the sheet would show all entries under that name, with a reset button. Do you have any idea how I could do that ?
 

Thanks in advance;

[LogicalDrm]

1) that's messy formula. If you can share some of the data, it's easier to help. Like even how it's organized. In the formula you have quotation marks closing your logical test for If-function.

 

2) That should be possible with Vlookup. But do you want to have that inside Sheets or used with external website?

[Reddox]

On 12/24/2020 at 1:06 PM, LogicalDrm said:

1) that's messy formula. If you can share some of the data, it's easier to help. Like even how it's organized. In the formula you have quotation marks closing your logical test for If-function.

 

2) That should be possible with Vlookup. But do you want to have that inside Sheets or used with external website?

Hi,

I've resolved my first problem, but, for the second, let me share the example :

So, the idea is that when someone enters a name IN the spredsheet, the sheets indexes all lines where the name appears.

Unfortunetly, I have no other choice then using a spreedsheet

[LogicalDrm]

2 hours ago, Reddox said:

Hi,

I've resolved my first problem, but, for the second, let me share the example :

So, the idea is that when someone enters a name IN the spredsheet, the sheets indexes all lines where the name appears.

Unfortunetly, I have no other choice then using a spreedsheet

Vlookup then. To use buttons for apply/reset would require scripts (either Javascript etc. or with Excel scripts). With Vlookup and Vlookup just entering values will update fields.

[camieabz]

Late to the thread, but consider named ranges and drop down lists.