The tag has no usage guidance.

learn more… | top users | synonyms (1)

0
votes
1answer
317 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
8k 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 ...
9
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
177 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
340 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
18k 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 ...
1
vote
1answer
323 views

Shell function parameter

Is there a way to declare and pass parameters for shell functions, like so ? function msg( m ) { read -p "Task #" + m + "done. Press any key to continue }
4
votes
3answers
1k views

How can I invoke a function in bash shell script

I just wonder the distinction calling the function between $(one_function) and one_function in bash shell script. When I set the variable PS1 in ~/.bashrc, I can't invoke the function by one_func ...
1
vote
3answers
658 views

Access 2007: How can I make this EXPRESSION less complex?

Access is telling me that my new expression is to complex. It used to work when we had 10 service levels, but now we have 19! Great! My expression is checking the COST of our services in the ...
0
votes
2answers
318 views

EXCEL generate a character in one column of a row, only if other columns in the same row are not blank

My speadsheet keeps track of when patients leave a specific floor of the hospital. There are columns in which where each patient goes is documented (1 column for "home", another column for "rehab ...
1
vote
1answer
992 views

Office 2008 Mac Calendar Wizard

I remember Office 2004 had a calendar wizard so that I can generate monthly calendars for a range of months. Like print out calendars from Jan 2010 to July 2010. I cant seem to find the wizard or ...
2
votes
2answers
1k views

Excel Table lookup with indexes in multiple columns

I have a Table in Excel the looks about like this: Test1 100 test2 200 Test3 110 test4 210 Test5 120 test6 220 I want a function that, given test 1 as input, will return 100 AND given ...
0
votes
1answer
1k views

Vim: Custom Folding function done, custom highlighting required

I have defined a function in vim to properly indent folds. Ie so they look like this: Unfolded this is text also text indented text indented text not indented text folded with default ...
1
vote
1answer
137 views

Return the date of the day under an if formula with Excel or VBA

I have two columns A and B and many lines with some specific tasks to be done. In column B, I have a drop-down list with the name of people who are scheduled for the task . And in column A, I want the ...
12
votes
4answers
18k views

How to call bash functions

Maybe I am looking at this the wrong way.. But here I what I am trying to do. Do most of my work with Java but just switched to a unix (bash) environment. I am doing this: [~/Desktop/bashPlay]% ...
3
votes
3answers
5k views

How can I switch the function and control keys on my laptop?

I have an ASUS X51R laptop and the left function/control keys are swapped as shown in the picture below? Is there some way to remap these keys so that CTRL is on the far left as on a standard ...
0
votes
3answers
141 views

Is a shell function better than the same function in PATH?

I have been slightly confused about the extraneous use of shell functions. My definition of a shell function: a function which is in .bashrc such that .bashrc --- other default bash configs ---- ...