The tag has no wiki summary.

learn more… | top users | synonyms (1)

1
vote
0answers
10 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
1answer
9 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
26 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
13 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
0answers
12 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
39 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
16 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
62 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
1answer
19 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
21 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
36 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
41 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
0answers
25 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
1answer
17 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
0answers
278 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
0answers
33 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
1answer
110 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
51 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
31 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
624 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
57 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
54 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
93 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
1answer
381 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
18 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
1answer
3k 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
1answer
410 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
1answer
67 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
1answer
92 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. ...
0
votes
1answer
743 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 ...
4
votes
1answer
605 views

ms excel find and replace @ symbol results in broken formula

I'm trying to search and replace in excel, the column is formatted as 'Text'. Find: [@ replace with: @ Whenever this finds a match at the start of a cell i.e the cell contents start with [@ and ...
0
votes
3answers
174 views

Excel - Referring to a certain cell based off of data in another

I have a spreadsheet where there is one table with the headings: Coordinate, Lat, Long Another with headings Triangle, Coordinate 1, Coordinate 2, Coordinate 3, Area What this is for, is taking ...
0
votes
2answers
241 views

Excel VBA Right Function Error

I'm trying to automatically update the date range on the top of my report in Excel based on the date range from data I download from a text database. In the below listed macro I get a Run-time error ...
0
votes
1answer
645 views

Ignore “[Value_if_false]” when value is true

In Excel, I am using an IF function and using the OFFSET function to assign a value in the [value_if_true] and using a 0 for the [value_if_false]. The true OFFSET function was occasionally returning ...
1
vote
0answers
185 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 ...
0
votes
0answers
87 views

Batch file function is executed without being called

I defined a function, the strange thing is that the function lines are executed even if I do NOT call the function !! echo off cls REM call:ctrlService "stop" "1.1.1.1" echo.SERVICES STARTED ...
2
votes
1answer
981 views

Excel formula for one cell to repeat across a different column (perhaps IF command)

I'm wanting to look up if a series of values (Column N) fall within a specified range. Currently trying this: =IF(AND(N:N<=C2,N:N >=L2),"YES","NO") This does not properly work. I want to ...
3
votes
1answer
7k views

Combining two IF functions in one cell using Excel 2010

I have these two IF functions that work correctly on their own. I need to combine the two into one cell but can't seem to get them to work. Any help would be appreciated. And thanks in advance. ...
1
vote
2answers
8k views

Excel- If multiple cells in a range are blank, return an answer

In Excel (365 edition), I want to have a formula determine whether in a range of 5 cells, 3 of those cells are blank. If there are 3 cells, I want it to display INELIGIBLE, if there are fewer than 3 ...
2
votes
1answer
1k views

Excel: Reverse VLOOKUP with comparaison

I have an original table (the value column is sorted): name | id | value --------+-------+------- abc | 1 | 12 def | 2 | 15 ghi | 3 | 23 jkl | 4 | 29 ...
0
votes
1answer
38 views

Why is GVim displaying the output from system() function as ^M and ^@

function! g:insert_date() let l:pattern="\\d\\{2}:\\d\\{2}" let l:match=match(getline('.'),l:pattern) let l:curline=getline('.') echo "Current line: ". l:curline normal gg ...
0
votes
0answers
31 views

Excel String compare [duplicate]

I am trying to compare string and then display the what doesn't match between the two of them, for example: take A1 which contains [alpha:beta] and then B1 which contains [alpha] and it will match ...
1
vote
1answer
452 views

Exporting bash functions through ssh

So I found a way to transfer environment variables through ssh without having to change neither server nor client: Transferring environment variable through SSH / quoting in bash/sh/csh/tcsh But I ...
-1
votes
1answer
106 views

Emacs - Specific Bracket Behavior Customization

In emacs, I prefer the electric-pair-mode behavior for parentheses and brackets as opposed to what seems like the "jumpy" default behavior. However, I currently use auto-newline and like the ...
0
votes
2answers
4k 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
2answers
61 views

May someone be able to fix this function please?

Like, what is the problem with it? =IF(F2>6,=A18*0.5,=A18*0.6) It keeps on making it just say =A18*0.5, not the actual contents of half of A18. So can someone try make this work? All help ...
1
vote
3answers
941 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 ...
1
vote
1answer
525 views

Call on a cell in Excel up to the first semi-colon

I am using the =CONCATENATE function, and one of the cells I'm calling on I only want to take the value in the cell up to the first semi-colon. Is this possible, and if so how?
0
votes
1answer
201 views

Easy MS Excel - MIN column with IF condition checking another column

I'm analyzing some personal expenditures for somebody on Excel. I have a column for calendar dates and a column for expenditures on that date. Of course, there are days when there are no expenditures ...