Help needed with Median If in Excel

Assuming your categories are in cells A1:A6 and the corresponding values are in B1:B6, you might try typing the formula =MEDIAN(IF($A$1:$A$6=”Airline”,$B$1:$B$6,””)) in another cell and then pressing CTRL+SHIFT+ENTER. Using CTRL+SHIFT+ENTER tells Excel to treat the formula as an “array formula”. In this example, that means that the IF statement returns an array of 6 values (one of each of the cells in … Read more

strdup() – what does it do in C?

Exactly what it sounds like, assuming you’re used to the abbreviated way in which C and UNIX assigns words, it duplicates strings 🙂 Keeping in mind it’s actually not part of the ISO C standard itself(a) (it’s a POSIX thing), it’s effectively doing the same as the following code: In other words: It tries to allocate enough memory … Read more

strdup() – what does it do in C?

Exactly what it sounds like, assuming you’re used to the abbreviated way in which C and UNIX assigns words, it duplicates strings 🙂 Keeping in mind it’s actually not part of the ISO C standard itself(a) (it’s a POSIX thing), it’s effectively doing the same as the following code: In other words: It tries to allocate enough memory … Read more