The tag has no wiki summary.

learn more… | top users | synonyms (1)

2
votes
1answer
39 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 ...
0
votes
0answers
5 views

R function that calculate correlation between two elements of a data frame if condition is meet [migrated]

So I've been trying to make this function work for days.. function behaviour should be as follows: go throw a number of specified csv's = id read.csv's and rbind them all in one dataframe remove ...
-2
votes
3answers
66 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
2answers
54 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)) ...
1
vote
1answer
7k views

AutoHotKey how to pass/evaluate parameters to functions

I'm having trouble understanding how parameters are accessed in AutoHotKey functions. For example, I set myVar variable with the InputBox, then pass it to a function. How do I evaluate the arg in the ...
1
vote
3answers
3k views

Display multiple cells if data on another workbook contains “X”value

I export a complex report daily and I transfer that information manually into another excel sheet. My question is: In workbook 1, can I get a group of cells in a row to display the text in workbook 2 ...
0
votes
1answer
41 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
1answer
74 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
1answer
54 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 ...
3
votes
1answer
39 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 ...
0
votes
1answer
2k views

split a large excel into smaller files but include the header in all files

I have a macro that I use to break large excel spreadsheets into smaller files. It works perfectly, except, it only uses the header row in the first file created and this header row (row 1) needs to ...
0
votes
1answer
54 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), ...
2
votes
1answer
35 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
1answer
33 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
0answers
36 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 ...
1
vote
3answers
16k views

How do I assign a number value to a non-numerical value in Excel

I have some survey responses with values like "VU" for "Very Unlikely" and "S" for Sometimes. Each survey response occupies a cell. For each cell containing a survey response, I want to fill another ...
0
votes
0answers
32 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
2answers
54 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
1answer
4k 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 ...
1
vote
1answer
27 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
1answer
18 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
1answer
133 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?
2
votes
2answers
65 views

Rename selfdefined function

Having a precmd() that does quite a lot, like checking for VCS information, I want to disable it when I'm navigating on slow mounted network drives. I came up with the following with which I can say ...
0
votes
1answer
25 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
1answer
34 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
0answers
41 views

Formula to copy rows to a new worksheet based on a single value in a row

I need to extract complete rows from a spreadsheet to a new spreadsheet based on a specified value in the row. Cannot be advanced filtering since that only allows me to copy into same worksheet. Is ...
0
votes
1answer
45 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 ...
3
votes
2answers
137 views

How can I get the place where a function is defined in VIM quickly?

I've installed taglist and nerdtree plugins, and I wonder if there's way to quickly find the location where some function is defined, just as what Control and pressing function name in Eclipse does? ...
0
votes
0answers
26 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
2answers
1k views

Multiple IF Then Function

I know this shouldn't be this difficult, but what I am looking to do is I want a total in A5 based on a running total in A1 through A4. For example, if A4 is blank then input A5=A3, if A3 is ...
0
votes
2answers
5k views

How can I use multiple IF functions in Excel 2010?

Well, I am putting multiple =IF functions in a particular cell in Excel 2010. The Value if True part of the function is A18*0.5, however when I put more =IFs in the cell then the Value if True is ...
0
votes
1answer
19 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 ...
1
vote
3answers
7k views

Does Excel have a row filtering function (more general version of SUMIF/COUNTIF)

SUMIF and COUNTIF functions are handy for simple SUM and COUNT operations on only some of the values in a range, but is there a more general version that would allow me to plug in any other function I ...
1
vote
0answers
206 views

Plotting timedata in gnuplot

I have a log file (auth.log) where non-relevant lines has been removed. I wish to aggregate lines per hour/day into the plot, meaning that each line that is within the same hour or day is aggregated ...
1
vote
2answers
7k views

Quicker alternative to IF function for multiple variables? (excel 2010)

I have the following information in a table C D ----------- ----------- 1 | 25% | 1 | ----------- ----------- 2 | 50% | 2 | ----------- ...
0
votes
1answer
1k views

My bash script does not find an existing file

I realized a bash script that works on an existing text file located into the same working directory of the script. The script take name of the file to compute through a function parameter. The issue ...
0
votes
0answers
372 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
1answer
164 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
0answers
34 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
0answers
56 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
1answer
33 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
1answer
693 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
1answer
67 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
2answers
56 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
1answer
131 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
2answers
1k views

.bashrc reports unexpected EOF

I am trying to add some functions to my bashrc, namely: h () { history | fgrep $1 | sort -u | cut -b 8- } extract () { if [ -f $1 ] ; then case $1 in *.tar.bz2) tar xvjf $1 ;; ...
0
votes
1answer
475 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
1answer
19 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
3answers
1k views

How do I handle the failure of a command in a bash function?

I have a bash function on one of our test servers that deploys our code, but one of the commands fails frequently and we can't find the cause. We just retry until it works. I want to have the ...
0
votes
1answer
485 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 ...