The tag has no usage guidance.

learn more… | top users | synonyms

1
vote
1answer
23 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
21 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 ...
0
votes
2answers
70 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
42 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 ...
2
votes
3answers
33 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
39 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
179 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, . . . ...
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
47 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
18 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
59 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
1answer
140 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
371 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
100 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
44 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
191 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
152 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
66 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
221 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
5k 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
260 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
26 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 ...
0
votes
1answer
996 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
204 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
141 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
323 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
144 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
165 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
198 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
216 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
736 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
116 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 | ...