The tag has no wiki summary.

learn more… | top users | synonyms (1)

1
vote
1answer
568 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
209 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 ...
2
votes
0answers
706 views

Linux Mint 14 Cinnamon - Fn Keys Brightness Level Intervals

I have a question in regards to setting the brightness level on laptop display using the function keys; I have determined that my screen is capable of having it's brightness level set to values 1-10 ...
2
votes
2answers
60 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
136 views

How to get the data from one cell to alter the function of other cells

I have 10+ worksheets, with the same layouts, all containing data from different days jobs. I am trying to create a "SimpleSheet" that only pulls specific data from one days sheet in a nice layout. So ...
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 ...
1
vote
0answers
37 views

Custom function COUNTIFUNIQUES in Excel [duplicate]

Possible Duplicate: Excel: how to count number of distinct values in a range? I would like to create a custom function COUNTIFUNIQUES that extends the functionality of COUNTIFS. Here is an ...
-4
votes
1answer
64 views

Syntax for Functions in Bash

I do know the JavaScript syntax: var functionName = function(some perameter){ some code here; }; but what is the syntax for a function in bash?
0
votes
1answer
856 views

Libreoffice Calc - Fill with Sum is not working

I want to add 2 columns of data and output the sum into a third column, with a =sum(a1+b1). With many rows of data, I try dragging down the highlighted cell to Fill the rest of the output column with ...
2
votes
3answers
329 views

How do I make a bash alias that outputs file names in a format I can pipe to vim?

When rebasing with git, I'm interested to open the files that have merge conflicts. I can do this with: vi `git diff --name-status --diff-filter=U | awk '{print $2}'` but if I alias that: alias ...
0
votes
1answer
342 views

excel function searching multiple rows

I have a worksheet with a column (A) with dates. Some rows between dates are blank. I want to put a cell on another sheet that searches sheet1, column A for a particular date, and when that date is ...
4
votes
2answers
14k views

Change middle mouse button function in Windows

Is there a way to assign a function (like cut/copy/paste) to the middle mouse button or scroll wheel in Windows 7?
2
votes
1answer
1k views

How to return current record number in Access?

I want to have my table to automatically returns current record number. What functions should I input in default value of this field (indicated in blue arrow) in order to automatically generates ...
0
votes
1answer
964 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
2answers
4k views

How to divide the sum of cells by 7 and then transpose them in Excel

I need to take a vertical row of numbers in excel and add them all and divide by seven. I then need to transpose the result into 7 equal rows (one for each day of the week.) I have tried the ...
5
votes
1answer
1k views

overriding user defined functions with the same name as system commands

This function exists in one of my users' ~/.bashrc: function rm() { ls $* echo "rm?" read ans if [ "$ans" == 'y' ]; then /bin/rm $* fi } In ...
1
vote
0answers
128 views

Is there any way to use devices like mp3 players when they are charging? [closed]

The question is simple I think. All we have encounter gagets that they don't fuction while they are in charge, like cameras or mp3 players. But, we know that cell phones or laptops can have full ...
1
vote
1answer
2k views

Returning The Name of the highest value field

I have 4 field of Numeric Values, I want Excel To pick the highest value of them and show me the name of the field that is related to the highest one, for example: Option 1 (J10) Option2 (K10) ...
1
vote
2answers
6k 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
2answers
195 views

How do I add a value to a cell in Excel if it's an int?

I have an Excel table with some cells that are numbers and some cells that are strings. I want a function that can add search through the table, and if the cell is a number, add it(+) and if it's a ...
0
votes
1answer
996 views

IF function that refers to another cell if true

Can someone please help? I am using the IF function to find cells within certain ranges, but want the cell to contain the value if it falls within that specific range. for example: =IF (AA3 is ...
1
vote
3answers
627 views

Using a pre-existing function for a new row

I have an Excel document that contains X columns and N number of rows. The very last column of a row performs a SUM of the first X-1 columns. The problem I have is, the user of this Excel document ...
3
votes
2answers
7k views

Excel - define a formula in one cell to be used in other cells with different inputs like a function

I use excel 2010. I want to use a formula defined in one cell as if it was a user-defined function. Example: In A1 I put something like (I know it's not a real syntax): = 3 * Input + 15 And then ...
1
vote
0answers
106 views

Operating system functions

I am currently reading From Nand to Tetris (aka The Elements of Computing Systems) - highly recommended. Anyway, in the last chapter (which deals with operating systems) it says: Some functions ...
0
votes
0answers
44 views

Is there a twitter functionality to be selective with retweets?

At times, there are tweets that I would deem appropriate to retweet to specific lists or only to certain followers. I've had much experience using Twitter and third party programs like Tweetdeck but ...
3
votes
3answers
6k views

Can basic mathematics be done in Microsoft Word?

Is there a function of MS Word that enables users to solve basic math problems, in this case addition or subtraction? I use its platform for a budget and of course I could just use a calculator but it ...
3
votes
1answer
4k views

OpenOffice Calc - how to insert BLANK in a formula?

In Calc, as in most spreadsheet applications, an IF() function exists that can be used to control behaviour, for example inserting this formula in cell C1. =IF(A1>B1;"A";"B") will display A in ...
0
votes
1answer
49 views

Matlab: How do I put another function within a function?

I have a function in Matlab that produces three specific results. I want to use these results as input arguments to a following function to calculate the end result. How do I go about combining the ...
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 ...
1
vote
2answers
580 views

Excel macro date parser cannot handle single-digit days

From previous questions on this and other sites I was given a function that can parse for and find dates in text strings or cells. Here's the function: Function GetDate(strInput As String) As Date ...
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 ...
5
votes
4answers
13k views

Excel VBA Function runtime error 1004: Application-defined or object-defined error

I'm trying to learn functions for the purpose of simplifying and reusing code whenever necessary. I began by turning something I use pretty often into a function: Returning the integer value of the ...
1
vote
3answers
904 views

Regular keyboard stuck as if a laptop function key was pressed

I have a regular PC keyboard plugged in a desktop PC with Windows 7 When I switched on the computer today I discovered that pressing U writes '4', O writes '5', K writes '2', etc. exactly as if you ...
3
votes
1answer
483 views

Function which overrides bash command

Is it possible to call a bash command which has been overridden with a function? I'd like to make pushd with no arguments alias to pushd . otherwise get normal behaviour. I've tried pushd(){ if [ ...
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
1answer
876 views

Changing numpad key function when numlock is off?

So I've got a new Acer notebook and the keyboard is laid out like this: I want to be able to change the left and right arrows of the numpad to volume down and up and the 5 key to mute but still be ...
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 ;; ...
3
votes
0answers
1k views

How to add support in Function List for a new user-defined language? (Notepad++ Win7 64bit)

I'm writing in a user-defined language called 'Umajin' (*.u), which has a syntax quite different from C/C++ or any ECMAScript-based language, so we've had to write in the rules for the highlighting. ...
0
votes
1answer
3k views

Function generator for PC soundcards

I'm in need of a function generator, but I want to avoid buying dedicated laboratory instrument. My idea is to use computer's sound card to create signals (yes, I know that it's not a replacement for ...
0
votes
1answer
313 views

When switching to another doc, Function Argument window disappears?

I have problem with Excel 2007 when using VLOOKUP function. After switching to another document for referencing value in "Table_array" field, window dissapears. Google finds some results about the ...
2
votes
2answers
5k views

Turn off laptop back light without keyboard in Windows 7

How do I turn off my laptop's back light using a shortcut, or a program in Windows 7? I have a Gateway NV59 and can press Fn + F8 to blacken the screen. At night, while watching a movie on my other ...
0
votes
2answers
73 views

brightness of the screen not adjusted

i have sony vaio vgn series laptop,after xp installtion function keys are not working.....i have installed all appplications n drivers available on sony website n compatible with my model....kindly ...
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 ...
0
votes
4answers
4k views

Function key emulator for Dell inspiron 6400 on external keyboard

I have a 3 year old Dell inspiron 6400 with windows 7 and ubuntu 9.10 dual boot. I messed up my Laptop keyboard and hence my Fn key is not working and I need it to activate the wireless whose ...
7
votes
1answer
2k views

How do I unset or get rid of a bash function?

If you set or export an environment variable in bash, you can unset it. If you set an alias in bash, you can unalias it. But there doesn't seem to be an unfunction. Consider this (trivial) bash ...
1
vote
1answer
176 views

Replicating common Excel Functions

I am always curious how some of the functions I use in excel were written, and think it would help at times to see how it was done. Does anyone know where there is example vba that replicates what ...
1
vote
2answers
337 views

Conditional Lookup in Excel

I want to use excel to compare pairs of numbers from the "Pre/Post" column of the following data: Student Course Pre/Post Score K300997203 FHS120100417 Pre 3 L286197217 ...
13
votes
5answers
2k views

Finding the definition of a bash function

I work in an environment that has a lot of legacy shell script magic lying around. One thing used heavy from the command line are bash functions that get sourced from some file included from some ...
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? ...
1
vote
3answers
14k 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 ...