Tag Info

New answers tagged

2

You can set up a 'custom' validation. This gives you a formula option. Here is an example formula that you can customize: =IF(LEFT(D5,9)="superuser",1,0) So, you would select the cell (ex. has d5), select data validation, choose allow 'custom', enter formula. Formula should return 1 if valid and 0 if invalid. Notice that I entered D5 for the ...


1

As long as you know exactly what string your are checking for this should work (assuming checked cell is A1). Basically it checks if the first 9 characters are superuser and returns a true or false. You can change the number and checked term to whatever you need. =IF(LEFT(A1,9)="superuser","True","False")


0

IFERROR is a very convenient function; IFERROR(calculated_value, default_value) is short for IF(ISERROR(calculated_value), default_value, calculated_value) i.e., it substitutes a default value (typically a non-error value) for an error value.  So you probably want something like IFERROR(AVERAGE(E8:E19), "") replacing the "" with whatever you want to ...


0

Have you tried using the error-catch function in Excel? As you have said, if you take the average of only blank cells, Excel will provide a result of Div/0. Let's say there are 3 people (A,B,C) reviewing a recipe for Guacamole. Let's say the csv looks something like this: Ingredient,Score A, Score B, Score C Avocado,1,2,3 Cilanto,,, Lime,1,2,3 ...


1

Steven, here is one possibility if you don't want to go the macro route. Have your master list of titles as a named range with the unique number next to it (e.g., A. Approaches to Sustainable Agriculture, B. Economic Sanctions in U.S. Foreign Policy, A1. Trials of the Century). Make sure you have enabled autocomplete in cell (in backstage view, Options, ...


2

My suggestion is a combination of list and vlookup() in a separate cell. As with most things in Excel, there is probably more than one way of doing it, but this is the first thing that comes to mind. I.E. limit answer to text in a defined list using data validation. To the right of each item, specify the number you want to translate to. Then, in a ...



Top 50 recent answers are included