Excel Chatroom
The Excel Maniacs have an Excel Chatroom.
Just needs some chatters…….
An addin to integrate the chat with Excel could also be interesting (you could chat from the web or inside an Excel popup/form).
Can't get the tutorial to work for you? Need help with your code?
Get answers right away at our AE Excel Support Forums!
Get answers right away at our AE Excel Support Forums!
how do i unshare a workbook being used by 3 computers
Tools->ShareWorkbook, then uncheck the “allow changes” button
???
How do I convert averaged figures to 2 decimal places??
just hit the +0.000 key in the tool bar
I have a need to validate drop down lists. I have a list in column A – with 5 values. Now, depending on which value is chosen, I want to validate data in another column. Is that possible without writing a macro?
Hello Jack,
I am not totally sure what you’re asking, however you could probably use either:
a simple If statement,
a “Vlookup”
or even potentially a pivot table to do what you want.
Hope that helps.
Excel is missing the file menu on my computer. Anyone know how to activate it? I’m on Excel 2004 for Mac, version 11.2.
Thanks!
I need help in recovery. I did some work in an email in excel 2007. The data entered did not hold. How can I recover. Any idea’s appreciated.
I have a question about excel. Is anyone there to help with this?
I have a question about averageing the cells in column A that correlate with the cells in column B that have the exact same value.
In other words I want to average all of the cells in column A that have a value of X in column B and then do it again for all the cells that have a value of Y.
Can anyone help me with this?
I am missing the “File” button on my main toolbar, how do I bring it back?
Sir, I want to know that if I feed just a month and the list of names should automatically be copied from the range, how it’s possible with excel and if macro can u give it’s code or file to me plz……
I need to make a spreadsheet based on monthly collections of termite renewal payments i would like to break it down into percentages- why we have not received a payment
does not want service
incorrect phone # or disconnected
new homeowner
and so on. Can anyone help me
I need to do an IF statement for a data set. My data includes a list of my retail locations in column A and in row 1 i have the months during the year (Jan thru Dec). For each location I have the sum of hours worked in each month by all of my employees. From January thru June I have 190 hours worked and from July thru December I have 240 total hours worked. I need to do an IF statement that will give me the month wich is listed in row 1 of when the increase happened. So I want the IF statement to indicate that July is the month the total hours changed. I need this statement because each location has different hours and different months in which the increase happens.
Please help
Thank You
Hey, I’m trying to take some information which are numbers and count how many numbers are between 1.6 and 6.6, I can’t figure out how to get it to count them. How do I do this?
I’m trying to come up with a formula that looks at Column A (“Date”)(a5:a20) – if the date is within the month of April, I want to then look at Column G (“Categories”)(g5:g20) to look at all categories marked “bills” – I then want to add up all the “bills” transaction amounts… Column E (“Debits”) and place the sum of those numbers in an individual cell.
I would like to be able to do the following. I need to be able to list numbers into a cell and then take those numbers to a column and list each number in a cell in numeric order. The tricky part is if I enter a already entered number it alerts me.
Hi – are there any guru’s out there who can help me with advanced filtering? In my ‘Criteria range’ I need to find rows that ‘contain’ the value in my criteria range not that ‘equal’ it….does anyone know if this can be done?
hey! im trying to make a game using excel vba and userforms. can anyone help me? i need to make a connect4 AI. also, im trying to make a ball bounce because were trying to make a ricochet excel game. any ideas or help? thanks!
How do I change the labels down a column to labels across a row without cutting and pasting each lable separately? I have done this before, but have forgotten how!
Hi
Could someone please help me on how to link data in a new worksheet from other worksheets. Are there any formulaes i can use
Thanks in advance
I need some advice. I work for a company that publishes manuals and every time there is a minor change for each of the programs, I need to use a system to keep track so that our writers have access to the most up-to-date info. I have been using excel but its getting unmanageable. I have a keyword search, and I’m building tabs to divide each manual into chapters, but does anyone have ideas?? I’d be open to other programs!
i am trying to drag a formula from one cell to the other. it will drag but mot calculate the correct amount
I want to be able to add a negative number in excel, for example, -5 (C1) + 3 (C2) = -2 (C3). I tried adding in the function bar: -(C1) + (C3) = (C3). It did not work… How can I add this formula in excel? Any suggestions?
Have a problem, I need code in Excel that will allow me to populate a cell that will meet the following criteria- has to do with student grades.
Will use student scores-if total score= 0, then student needs A to pass
= .25, then student needs B to pass
= .50, student needs C to pass
= .75, student needs D to pass
=1, student is “OK”
would you use an “if” statement or what?
THANKS!
This paragraph is in Arial, size 5, and in red text color.
I am trying to create a list that recognizes the description and automatically inputs the description and price. for instance:
description qty description price total
2x4x8 0 ea 2.49 =sum(b2*d2)
baseboard 0 ln ft 1.40 same as above
i want it to automatically recognize everytime i put baseboard in that the description is ln ft and the price is 1.40.
how do i do this