The function tag has no usage guidance.

**0**

votes

**0**answers

12 views

### excel 2013; using if function, punctuation in true statement shows up even when value is false

In Excel 2013, when using the if function, and when the value if true contains & and punctuation, punctuation shows up even when false.
i.e.:
(CONCATENATE("Actual ",TEXT(X13,"hhmm")," - ...

**0**

votes

**0**answers

9 views

### Compare 2 columns As in 2 separate sheets and if they match add column Bs from each sheet together

I have 2 separate sheets with 2 columns. I am looking to match Column A from both sheets and add the value of column B to each other and input the sums in a different column. looking for help.
...

**0**

votes

**1**answer

14 views

### how to pass path 'cd' portions to a shell function?

I'm trying something like this:
function projects(){
cd;
cd Documents/projects/$1;
}
but it doesn't work. What I'd like is to pass the name of the folder to add to the base path (so resulting ...

**1**

vote

**2**answers

49 views

### Excel Help - Is it possible to return the column number of the 2nd match within a horizontal array?

I'm trying to return the column number that corresponds to the 2nd occurrence of zero in the following table:
B C D E F G
2 0 0 3 4 9
For ...

**0**

votes

**0**answers

31 views

### Excel - Can I create a list of values with criteria and have excel make a list with parameters?

In Excel, I am trying to see how many combinations I can make with the allotted criteria and such.
So lets say I want to know how many combinations of groceries I want to buy for a certain budget. ...

**0**

votes

**1**answer

15 views

### Date values from SQL cannot be filtered in EXCEL

I created a VIEW in SQL which contains a date column.
The date column is defined as datetime ,I had to use CONVERT (nvarchar.mydate,103) so I can get the following format : dd/mm/yyyy.
Now when I ...

**1**

vote

**1**answer

51 views

### Excel Sort and Lookup Values Formula

I am trying to create some sort formulas on excel.
An example is shown below regarding players and their corresponding scores. I need to query the "Raw Data" and get the "Top 3" players and their ...

**1**

vote

**2**answers

32 views

### AWK - Add variable and result of function to variable

I want to add variable and result of function in AWK. Input:
t t t t
a t a ta
ata ta a a
Script:
{
key="t"
print gsub(key,"")#<-it's work
b=b+gsub(key,"")#<- it's something wrong
}
END{
...

**1**

vote

**1**answer

20 views

### How do I change what each of the fn keys do?

How do I change how my function keys work? On my one computer, the f1 and f2 keys change the volume. When I go to my second computer, they are at f11 and f12. I always seem to accidentally hit f1 and ...

**2**

votes

**1**answer

93 views

### Creating a line graph in excel with changing/result cells

For a project we are creating care packages for the homeless. I am trying to figure how many kits to make for the least leftover material as the things we are putting into the packages are sold in ...

**2**

votes

**1**answer

152 views

### Use Excel to match data from a cell on a worksheet, then copy data from its neighboring column and paste on a different worksheet

I have a spreadsheet with multiple names and phone numbers next to them in each Sheet 1 - Sheet 5.
Each Sheet has about 900 names on column A and their associated phone numbers next to them on column ...

**0**

votes

**1**answer

304 views

### Excel: Check if column A has a specific value, if so, display another cell within the row where the value is located

How would I be able to write a formula that checks if column A has a specific value, and if so, displays another cell within the row where the value is located. From the example below, I want to find ...

**2**

votes

**2**answers

91 views

### How to create a data series for exponential decrease diagram

I want to create a pricing model this way:
If you need this product for 50 people, you should pay 2500 (units) per person.
.
.
.
.
If you need this product for 10,000 people, you should pay 300 ...

**2**

votes

**1**answer

79 views

### Function using watch on command with command line arguments

I want to run watch on a command which uses an optional command line argument, like this:
function queue() {
watch -n 10 'squeue -p ${1:-default} -o "%.8i" '
}
but the command-line argument ...

**-2**

votes

**3**answers

180 views

### Need a formula for Leap Year

I need a formula in which, if the date is equal to or greater than 03/01/2015 and less than or equal to 02/29/2016 then I get the result as "Leap Year" or "No Leap Year".
Thanks!
Sumeet

**1**

vote

**2**answers

104 views

### Why is my constructed formula giving different results than the same formula as UDF in Excel?

Here's a long formula to calculate distance between two coordinates points on Earth
=ACOS(COS(RADIANS(90-LAT1)) *COS(RADIANS(90-LAT2)) +SIN(RADIANS(90-LAT1)) *SIN(RADIANS(90-LAT2)) ...

**0**

votes

**1**answer

289 views

### How do I stop the Now() function from updating everytime I open the file?

I need it to automatically grab the value of current time at a particular moment when the user does a specific action (like pressing a button maybe). The thing is, I need it to keep that value of ...

**-2**

votes

**1**answer

133 views

### Determine if a financial year has a leap day in it in Excel

Our financial year runs from the first of March to the last day of February. I need a formula in Excel that tells me if the financial year has a leap day (the 29th of February) or not.
For example ...

**0**

votes

**1**answer

109 views

### Split data in half evenly by adding column with value: 1 or 2 based on specific cell value - excel

I have a query I pulled from a database with student information. The table has the following columns: StudentID, CourseID, CourseGrade.
The CourseGrade column can contain any of the following ...

**0**

votes

**1**answer

223 views

### Excel formula - is it possible to return a value adjacent to a list of values, depending if that list of values matches another list?

In Sheet 1, I have a list of document numbers (alphanumeric) in Column A, which have a corresponding title listed in Column B.
I need to compare another list of document numbers (alphanumeric), ...

**4**

votes

**1**answer

95 views

### Taking an indirect reference in Excel and making it a direct reference

For many somewhat complicated reasons â€“ it has to do with transposing columns and rows because of third party software limitations, etc. â€“ I have had to use the INDIRECT function in order to make ...

**2**

votes

**1**answer

255 views

### How to save user made zsh shell functions and aliases

Shell beginner here! I'd like to create aliases and functions in zsh shell to speed up my workflow. For example:
tw() { open -a //Applications/Textwrangler.app "$*"; }
The function itself works, ...

**1**

vote

**1**answer

53 views

### I am trying to use the if function to look at cells to the left and leave the cell blank if they are blank or calculate if they are not

I am trying to use the if function to look at cells to the left and leave the cell blank if the reference cells are blank or calculate if they are not. for example I have E14 that im putting the ...

**0**

votes

**0**answers

85 views

### making a running total for excel using countif function, 1 out of 14 drop down options don't work

So im using a table in excel, with several different headings in several collumns, (not pivot just standard) colomn A's name is "status", under these headings are several (about 900) different cases ...

**0**

votes

**0**answers

61 views

### lapack.h missing (?) dgesvd function

I try to compile VegaFEM but I get this error:
../../libraries/matrix/matrixPCA.cpp:182:30: error: â€˜dgesvdâ€™ was not declared in this scope
&LDVT, work, &LWORK, &INFO);
I googled ...

**1**

vote

**2**answers

101 views

### Vim Avoid “Hit the enter key or enter a command”

I have the following configuration in my .vimrc file to switch between a .c File and it's corresponding .h File
function SwitchHeader()
w
if(&ft=='cpp')
e %:r.c
...

**1**

vote

**1**answer

42 views

### Color coding data based off another sheet

I have a main sheet with names along the side, and authorized equipment along the top. I have separate sheets for each individual with all their assigned equipment. How can I make the corresponding ...

**0**

votes

**1**answer

28 views

### How do i get only the “dd” from a date cell?

I have a list of dates shown like this "1/1/2015" and/or "23/12/2015".
I would like to place a function in another column, in which I will have only the "dd" value from the date.
ex. for 1/1/2015 I ...

**0**

votes

**1**answer

316 views

### minimum of non-zero non-adjacent cells in MS Excel

I know that for finding the minimum of non-zero cells in Excel, I can use
min(if(A1:A10>0,A1:10))
But what if I would like to find the minimum of non-zero & non-adjacent cells?

**0**

votes

**1**answer

28 views

### setting up variables and the results from a function within a string - all as a string in powershell

I am new to this and could use some assistance.
I have the following function and trying to add the result from the function into the strings below.
What am I missing to accomplish this? I just want ...

**0**

votes

**1**answer

45 views

### How to use excel 2010 functions to caculate the sum of distinct unique values?

How to use excel 2010 functions to caculate the sum of distinct unique values?
remove the duplicate values
sum of distinct unique values
but I don't need to know who are the distinct unique values, ...

**0**

votes

**1**answer

55 views

### MS Excel | how-to SUM combination of array/absolutevalue

When using Microsoft Excel you can use the SUM function to add multiple cells, like so:
=SUM(A1:B7)
Let's say Row-A is an array set of numbers per cell (numbers totalled by formula) and Row-B is ...

**0**

votes

**0**answers

35 views

### Windows 7 with MS office 2010. Excel issue

Excel
Referencing text from another sheet (not another book).
Have a 'summary' sheet and want to reference text from other sheets.renamed '1' to '40' and have a real problem getting it to work. I'm ...

**0**

votes

**1**answer

24 views

### Autostarting a script at boot doesn't recognize the function “function”

I'm trying to get a script containing a function to run just after root autologin on TinyCore 5.3. The script works fine if I launch it from the prompt after login like this ./script.sh
But when I add ...

**0**

votes

**0**answers

524 views

### LibreOffice calc countifs with date

I got 3 columns. 1 column(D) text, 1 column(T) 0 or 1, 1 column date(A) 01.01.2010 till 31.12.2014 .
I want to count up until a specific date, for example 10.10.2011:
...

**0**

votes

**0**answers

36 views

### Do functions/aliases defined in a bash script that's downloaded from a server and executed not work?

I had a .bashrc which I moved to server so that I can download and execute it through wget.
wget -O - http://xxx.github.io/dotfiles/bashrc | bash
It does get executed but any functions and aliases ...

**0**

votes

**1**answer

255 views

### Excel 2010 offset function returns #VALUE! error

I'm trying to use the offset function in excel 2010, but it gives me a #VALUE! error.
The function works perfectly, if it's like this:
...

**0**

votes

**0**answers

68 views

### Excel function with the same name as cell reference

I'm using an add-in to Microsoft Excel called Isoplot, it's used for analysing and processing radiometric data for dating geological materials etc.
One of the user defined functions is intended to ...

**0**

votes

**1**answer

35 views

### Naming of custom bash functions [closed]

I recently decided to get into making my own bash functions and started with two easy ones hex2dec and dec2hex but the names of these are not unique enough. Like for dec2hex, it won't autocomplete ...

**0**

votes

**1**answer

752 views

### Asus R510D with Windows 8: Want to change volume with one button, rather than fn+F10/F11/F12

I have a new Asus laptop (R510D-FH11), and I would like to change the volume with one keystroke. As it is, I have to hold down fn+F10 or fn+F11. Because of my keyboard layout and average-sized female ...

**0**

votes

**1**answer

136 views

### =randombetween with a certain percentage between a narrower range

I want to randomly generate dates (within a four-year period) for 32 different records/rows in excel.
Additionally, I want 75% of those dates to be during one year in particular (within that four ...

**1**

vote

**2**answers

58 views

### Function that interpretes trailing 'n' characters of a word as argument

Is there a way to pass the trailing n characters of a command to a function, so that it executes it as two commands? For example I define my function as abcx and whenever I enter
abcxfoo
to the ...

**0**

votes

**1**answer

255 views

### Excel - Concatenate words separated by “_”

I need help with the following problem:
My column in A2 in Excel has the value: TB_PLACES_NAMES
But I need to separate the "_" from the others words in the same column.
I've tried this function:
...

**0**

votes

**1**answer

693 views

### Stop execution of a function after a given time in PHP

I have five exec() functions in my script. I want to set it up so that if a function fails to respond in a given time, the function will be killed and the next function will start its execution.
...

**0**

votes

**1**answer

23 views

### Find and then ask to perform action

I have a few macros to help refactor code that I have inherited. For instance, this macro adds spaces around a = character:
nnoremap <leader>bg /[^ ]=[^ ]<Return>a <Esc>la ...

**1**

vote

**1**answer

5k views

### How to create an Excel SUMIF formula that can compare different date formats

For my source data I have a column of dates in the dd/mm/dddd format, and a column of values next to it.
eg
03/02/2014 5
17/02/2014 4
03/03/2014 5
17/03/2014 4
On a summary sheet I have a ...

**0**

votes

**1**answer

643 views

### Converting Monthly data to Daily data on EXCEL for MAC

I have data columns of the last day of each month with a value. Apparently, the value of the entire month is stationary. I have to make a new column with daily dates while having the particular ...

**0**

votes

**1**answer

94 views

### How do I reverse a function button

My old laptop I could press f1 f2 etc no issue and to use extra features there was a function button to press with f1 for example to do something like volume control
My new laptop works the other way ...

**2**

votes

**1**answer

146 views

### Export bash function over SSH

I would like to export a bash function over ssh to use it in GNU parallel. That question seems to be answered here
Exporting bash functions through ssh
but I don't seem to be able to get it to work. ...

**1**

vote

**1**answer

991 views

### Passing parameters to python -c inside a bash function?

I need to print the value of a Django setting while in a Bash shell.
Basically, the command I'd like to run is python -c 'from django.conf import settings; print settings.MEDIA_ROOT'. I need to be in ...