The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
0answers
29 views

Is is possible to set the “expires” time based on “creation” time?

After using Keepass for several years, an idea came to me that would be nice to implement. There are over 300 records in my database, and it would be nice to know which of those records are still good....
0
votes
1answer
1k views

If Function is not working in Excel

I had made a sheet to calculate factory workers timing and payment against working and over time. First I made it in Excel 2013 and then I changed my Windows from 10 to 7 and also changed the ...
1
vote
1answer
24 views

Delete every row that doesn't contain a blank

I need to delete every row in Excel that does not contain a "blank" value in one of its six columns. I tried sorting each column, but there's 100k+ rows and that method really only works if I'm ...
2
votes
1answer
25 views

Bash Regex oddity when using =~ operator

Consider this code: s1="1,2,3,4"; \ s2="1,2,3"; \ sP='^(([1-9][0-9]{0,},){1,2}){1,2}$'; \ [[ "${s1}," =~ $sP ]] && echo "\$s1 matches"; \ [[ "${s2}," =~ $sP ]] && echo "\$s2 matches,...
0
votes
2answers
154 views

Need help to hide/show excel rows based on value in a cell, but allow for moving rows around later

In Row 4 I ask a question and D4 will contain the answer of either Yes or No. If the answer is Yes in D4, I want hidden rows 5 and 5 to appear with follow-up questions. This is working for me: If ...
1
vote
2answers
57 views

Multiple IF statements and concatenation in Excel

So far I've managed to concatenate cells I1 and J1 with the words "From" and "To" and put them on separate lines using: =CONCATENATE("From: ",I1," ","To: ",J1) I've also managed to populate column ...
2
votes
3answers
44 views

Using a wildcard in a condition to match the beginning of a string

Trying to have a variable meet a string of text that varies by length. The part of the string that matters is the first couple of characters. var1=hello if [ $var1 == hello ]; then echo ...
1
vote
1answer
47 views

Excel rearrange column using copy + paste

I am trying to create a method to automatically rearrange the column when performing copy + paste. Say I have an excel file with table containing columns on the first row: ID | NAME | DATE | ...
2
votes
2answers
182 views

Vector Compare to Scalar

Is it possible to compare a vector of values to a single scalar value in Excel? Example: =IF(A1:Z1 > 0, 1, 0) Typically, I've seen the following: =IF( AND( A1>0, B1>0, C1>0, . . . Y1&...
0
votes
0answers
23 views

using conditionals in environment modules

I am on a CentOS 6.6 system and I am trying to create some environmental modules. I have a package, HTSeq-0.6.1 that uses python and I wanted to have a conditional that checks the current version of ...
0
votes
0answers
51 views

Mail Merge Multiple IF Conditions for cell

I have a conditional statement for two cases (and default) which works fine. This is simply to enter a cell value based on another cell value in an earlier column simplified and shorm of extraneous ...
0
votes
1answer
21 views

Excel nested IFs

I'm trying to combine several IF formulas with an IF(AND formula but struggling. I can manage Nested Ifs or an IF(AND formula but can't seem to combine them. I want to say if L2 equals 1,3 or 4 then ...
0
votes
0answers
65 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")," - ",TEXT(...
0
votes
1answer
184 views

windows 7 search: multiple condition “find folders of this size that does not contain this and that”

Windows 7 search allows to find specific files type and exclude some using some operators (such as AND OR NOT) but how to add multiple search condition on these following example? Ex 1: this query ...
0
votes
2answers
450 views

Word 2010 Mail Merge Suppress Blank Conditional Mergefields

I cannot get a conditional Mail Merge to suppress blank lines in a relatively clean and efficient way. The only solution I have found is one I am not willing to use yet as I feel there may be a better ...
1
vote
3answers
111 views

Automatic text entry dependent on text in other cells [closed]

I have two columns of text and want to automatically enter text into the third column depending on the text in the previous two columns. It's a risk matrix; for instance if A1 says 'Likely' and B1 ...
0
votes
0answers
45 views

Excel 2010-populating table based on varying parameters

I am running a simulation run (5,000) of an equation that has several variables. e.g. A = B+C (more complicated than that). The variables B and C are generated using a norm distribution function ...
0
votes
1answer
219 views

AHK if/else of output from Custom Message Box Function

I've been trying to create a script that displays message boxes conditioned on the output from another customized message box with more than 3 options. The custom functions are taken form this thread ...
1
vote
1answer
182 views

If statement that returns original function if false (similar to iferror, or substitute)

If I use IFERROR as opposed to IF(ISERROR I can save typing the condition twice. i.e. =IFERROR(Long lookup,"not found") is much preferable to =IF(ISERROR(long_lookup),"not found",long_lookup) ...
0
votes
1answer
69 views

Excel cell value (text) based on 2nd cell value (number) appearing in a named range

I have a spreadsheet where I want a contact name to appear in a cell (F166) if the department number (P166) appears in a named range ("PS Depts" on Sheet2). Here is my existing formula, but it only ...
2
votes
1answer
47 views

IF and then condtional format

In Column C, I Want to rename the Column A Name in order of Date Of Birth, but only if a duplicate is found. Otherwise, the name in Column C should be the same as Column A. For example, there are ...
0
votes
1answer
247 views

AVERAGEIF based on formatting

I am using Microsoft Excel 2010. I would like to do an AVERAGEIF, with the criteria based on formatting. Ex: For cells, I choose A1-A3. A1 is the percentage value 10%. A2 is the number value 20. ...
0
votes
2answers
6k views

Excel - Compare two cells and display the larger number?

Can someone tell me how to compare two cells (numbers), and then display the larger cell? Cell C1 = IF A1 > B1 then display A1 else display B1 Sorry I'm not an excel pro.
0
votes
1answer
277 views

Excel (how to use if then else for the following condition)

cell 1>cell 2,cell 1<cell 4 print the value in cell 3 cell 1<cell 2,cell 1<cell 4 print the value in cell 4 cell 1>cell 2,cell 3<cell 2 print the value in cell 2 how to use these ...
1
vote
1answer
27 views

Odd issue with OR operator in zsh

I'm seeing an odd issue with CentOS 6.4, zsh 4.3.10 (x86_64-redhat-linux-gnu). This is running two regular expressions on the same string. Neither expression passes the if conditional, but when I OR ...
0
votes
1answer
1k views

Excel: formula to fill text data from sheet based on condition?

So, here's the situation. I have a workbook with several sheets. I've got one with a list of companies and their data (Tax ID, address, city, etc.) and another - working one. I have a cell with a drop-...
0
votes
1answer
1k views

SUMPRODUCT and IF conditional (LibreOffice) [closed]

I would like to multiply two cells in a same row, if a condition of a third adjacent cell is met; then sum the result to the next product in the next row (if condition is met), and so on. | A | B |...
4
votes
1answer
214 views

Batch File IF Statement Time Taken

I am trying to write a batch file that takes the time taken of a command and converts it into hours, minutes and seconds. Here's what I've got: @echo off set /a sec=0 set /a min=0 set /a hrs=0 for /...
0
votes
1answer
145 views

I'm trying to run a batch file that test for 4 different files then based on the correct file present it runs the correct command

:: batch file to run backup @echo off setlocal set backup1=="F:\my backups\Disk_1_DataBAckup" set backup2== "F:\My backups\2_backup_data_to_disk2" set backup3=="G:\my backups\3_backup_data_to_disk3" ...
2
votes
1answer
337 views

Bash script that execute command only if port is free

Hi I have a bash script that needs a conditional execution of a few lines of code based on whether port 80 is already in use: sudo git fetch origin; sudo git checkout master; sudo git pull; --- if ...
1
vote
1answer
147 views

what does =~ in linux means used in if condition to compare values

Actually tomcat/conf/catalina.properties file contains line shared.loader=/usr/share/sfit/conf I mean value has some path. so using shell script we are updating shared.loader values in file. And also ...
0
votes
1answer
178 views

Delete files which have almost identical filenames EXCEPT last word (Windows)

I'm trying to sort a directory of files with some conditions but I can't for the life of me figure this out. Here's a little example of some filenames which are to be sorted out (deleted). Turok 3 - ...
0
votes
2answers
206 views

How can I return a list of specific words found in a cell's contents?

I have two columns, one with a string of text (A1), the other blank (A2). A1 looks something like this: "Briefs on Southern Africa, Rhodesia, East of Suez (Including Soviet Naval Expansion), ...
1
vote
1answer
225 views

How do I write a conditional assignment in a Linux script?

I need to create a formula in a Linux shell script. If this was DOS, I'd (probably) be fine, but I've made the change and need to learn....! D1 = a 5-digit number between 40500 and 49500 (this is ...
0
votes
1answer
759 views

IF evaluation in Field codes checking for last page in Word 2011

I am trying to use the IF field code in Word but I am getting radically unpredictable behavior. My syntax is this: {IF PAGE = NUMPAGES "YES" "NO"} I have inserted it into a footer, text box, ...
0
votes
1answer
117 views

Sum of rows conditional on two conditions [duplicate]

I'd like to use array function to get conditional sum based on two columns. Given the example, for each ID I want to calculate the sum of value column if column B is -1 ID | B | value | ...