ewerk 30610 Posted November 28, 2018 Share Posted November 28, 2018 The oneupmanship in this thread is disgusting. 1 Link to comment Share on other sites More sharing options...
Leon 13 Posted November 28, 2018 Share Posted November 28, 2018 (edited) 2 hours ago, ewerk said: The oneupmanship in this thread is disgusting. Hey, I just provided the keyboard shortcut to your solution; your solution being the right one! Edited November 28, 2018 by Leon Link to comment Share on other sites More sharing options...
wykikitoon 20139 Posted July 29, 2019 Author Share Posted July 29, 2019 Word up Geeks Is there a way of excel looking along a column in excel, seeing a value and adding up those values? I.e I have a list of names of people and every time that name appears I want a cell to add up the total number that appears. Link to comment Share on other sites More sharing options...
ewerk 30610 Posted July 29, 2019 Share Posted July 29, 2019 =COUNTIF (range, criteria) The range obviously being the column and the criteria being the name of the bitch you want dead. Also use " " around the name. 1 Link to comment Share on other sites More sharing options...
strawb 4251 Posted July 29, 2019 Share Posted July 29, 2019 =SUMIF((a1:a30)=‘smith’) something along them lines, been a while 1 Link to comment Share on other sites More sharing options...
wykikitoon 20139 Posted July 29, 2019 Author Share Posted July 29, 2019 1 hour ago, ewerk said: =COUNTIF (range, criteria) The range obviously being the column and the criteria being the name of the bitch you want dead. Also use " " around the name. Top banana, worked a treat, thanks Link to comment Share on other sites More sharing options...
wykikitoon 20139 Posted August 15, 2019 Author Share Posted August 15, 2019 Another one for you geniuses. I have a spreadsheet with a list of dates. Is there an easy way to highlight those cells 3+ weeks out of date? Link to comment Share on other sites More sharing options...
wykikitoon 20139 Posted August 15, 2019 Author Share Posted August 15, 2019 Done it via conditional formatting. Check me out and googling it! Link to comment Share on other sites More sharing options...
wykikitoon 20139 Posted August 15, 2019 Author Share Posted August 15, 2019 (edited) Maybe fucking not I would expect the 05/08/2019 and 08/08/2019 not to be formatted. I.e red italic bold. Any ideas where I've fucked up? Edited August 15, 2019 by wykikitoon Link to comment Share on other sites More sharing options...
ewerk 30610 Posted August 15, 2019 Share Posted August 15, 2019 Why don't you ask your new friend 'google'. You two timing bastard. 1 Link to comment Share on other sites More sharing options...
wykikitoon 20139 Posted August 15, 2019 Author Share Posted August 15, 2019 2 hours ago, ewerk said: Why don't you ask your new friend 'google'. You two timing bastard. Not as good as you Link to comment Share on other sites More sharing options...
The Fish 10857 Posted September 29, 2019 Share Posted September 29, 2019 On 8/15/2019 at 14:39, wykikitoon said: Maybe fucking not I would expect the 05/08/2019 and 08/08/2019 not to be formatted. I.e red italic bold. Any ideas where I've fucked up? Isn't your formula asking Highlight this when Today() is greater than 20? Which all days after about 1990 are to Excel? It's 8:35pm on a Sunday so I might be wrong, but I'd "highlight the cells greater" than "TODAY()+20" Link to comment Share on other sites More sharing options...
ewerk 30610 Posted September 29, 2019 Share Posted September 29, 2019 Mate, at 8.35pm on a Sunday evening you’re trying to figure out an excel problem on an Internet forum that was asked and solved six weeks ago. Time to question your life choices. 1 Link to comment Share on other sites More sharing options...
The Fish 10857 Posted September 29, 2019 Share Posted September 29, 2019 17 minutes ago, ewerk said: Mate, at 8.35pm on a Sunday evening you’re trying to figure out an excel problem on an Internet forum that was asked and solved six weeks ago. Time to question your life choices. I see no proffered solution, fuckknuckle. Link to comment Share on other sites More sharing options...
ewerk 30610 Posted September 29, 2019 Share Posted September 29, 2019 Fair enough, I didn’t care enough to check. Link to comment Share on other sites More sharing options...
The Fish 10857 Posted September 29, 2019 Share Posted September 29, 2019 I accept your apology. Link to comment Share on other sites More sharing options...
Howmanheyman 33196 Posted October 10, 2019 Share Posted October 10, 2019 This fucking thread, man! 2 Link to comment Share on other sites More sharing options...
wykikitoon 20139 Posted December 10, 2019 Author Share Posted December 10, 2019 Righto @ewerka new one for you. I have text in one cell (someone's initials) and a calculated date in another cell. I want to place in ANOTHER cell, the total number of days the person has full for the month. How the chuff do I do that? Link to comment Share on other sites More sharing options...
ewerk 30610 Posted December 10, 2019 Share Posted December 10, 2019 I have no idea what you're asking for. I'm sure @The Fish will give you the answer in six months time. 1 Link to comment Share on other sites More sharing options...
wykikitoon 20139 Posted December 10, 2019 Author Share Posted December 10, 2019 (edited) I want to be able to get the total number of days of work added into the cell below the initals. So AB in that list would have 5 days so far etc. Edited December 10, 2019 by wykikitoon Link to comment Share on other sites More sharing options...
ewerk 30610 Posted December 10, 2019 Share Posted December 10, 2019 You just need to subtract the later date from the earlier date e.g. =D4-C4 Link to comment Share on other sites More sharing options...
ewerk 30610 Posted December 10, 2019 Share Posted December 10, 2019 (edited) I've noticed that in your initial cells the data is arranged vertically and in the second set of cells it's horizontal. If you calculate it initially vertically you can copy the results and use paste special and select values and transpose options. Without using absolute references there's no way to transpose the formula that I can think of. Edited December 10, 2019 by ewerk Link to comment Share on other sites More sharing options...
The Fish 10857 Posted December 10, 2019 Share Posted December 10, 2019 (edited) 9 hours ago, wykikitoon said: I want to be able to get the total number of days of work added into the cell below the initals. So AB in that list would have 5 days so far etc. Still not 100% what you're after, but if it's simply how many days AB has worked like Gloom says, either rearrange your 2nd table so it's a list and copy the formula across from the total Days column, orrrrrr just use a vlookup So say you've got those tables side by side and "Action By" is in cell A1 it would look like; =vlookup(F2,A1:D5,4,False) F2 is your reference, in this case "AB" in the second table A1:D5 is where you're looking, in this case the 1st table 4 is the column you want the number returned from, in this case "Total Days" False is the range your willing to accept, but because you're looking for AB and not any other variation on that type False =vlookup(What I'm looking for, where I'm looking,which column, this thing specifically) If you're copying this formula into more columns lock the range you're looking in by putting a $ before the letter and before the number like so -> $A$1:$D$5 You could use match index, but vlookups are fine for now. if this sin't what yo're after, you'll have to explain better. Edited December 10, 2019 by The Fish Link to comment Share on other sites More sharing options...
wykikitoon 20139 Posted December 10, 2019 Author Share Posted December 10, 2019 I sorted it, will show tomorrow thanks anyways Link to comment Share on other sites More sharing options...
wykikitoon 20139 Posted December 11, 2019 Author Share Posted December 11, 2019 I used this; Quote =SUMPRODUCT(--(G$7:G$1048576="GH"),J$7:J$1048576) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now