I use Win XP Home Edition, SP2, Excel 2003
Can someone inform me how to put Month, date, year and day of the week in
cell. I'd like to insert for example, 05/18/06 Wed
lt;formatgt;lt;cellsgt;lt;numbergt;lt;custumgt;
software 發表在 痞客邦 留言(0) 人氣(0)
Can anyone tell me how to plot a relative frequency histogram (using
midpoints). I know how to to make a histogram using the analysis tools, but
can't get Excel to put in plots for midpoints....
software 發表在 痞客邦 留言(0) 人氣(10)
I want to create a drop down box that displays a rebar size. upon selection
of the size, in the output cell designated, I would like it to display the
area of that rebar size. I can't use a simple if statement because there are
10 different size and you can only use 7 nested if statement. what can I do?
If your drop down is A1
software 發表在 痞客邦 留言(0) 人氣(1)
Is the newer version of XL that much better than 97?
I have a copy of Office '03 Student and Teacher edition, but have never
bothered to install it. Are the improvements in it actually worth the
effort to mess with it?
software 發表在 痞客邦 留言(0) 人氣(4)
I am trying to set up several data validation drop-down lists that are
conditional based on the selection in a previous cell. I got instructions,
but saw a note that this may not work in Excel 2003. Does anyone know if
this is possible? Let me know if I need to provide more detail on what I'm
trying to do. Thanks!
software 發表在 痞客邦 留言(0) 人氣(1)
I had my password written down for an Excel workbook, so I am sure I had it
right, down to the capital letter. I am now unable to open the workbook. No
one else had access to my computer. What do I do now? Thank you.
software 發表在 痞客邦 留言(0) 人氣(0)
I want to create a command button that will filter specifice product. Could
you please give me sample macro that filter data.
Thanks.
software 發表在 痞客邦 留言(0) 人氣(0)
I created an Excel spreadsheet and saved it to a network drive. When other
people edit the spreadsheet and try to save it they get a message saying the
file is set as read only. They are directed to save the file as another name.
The save dialog box comes up and saves the file as a quot;copy ofquot; the original.
If you right click on the file and go to properties the read only attribute
software 發表在 痞客邦 留言(0) 人氣(0)
Here's one play using non-array formulas which might also deliver this ..
A sample construct is available at:
www.savefile.com/files/9870225
Multiple search amp; auto-extract rows from 3 sheets based on key charge code
software 發表在 痞客邦 留言(0) 人氣(4)
Is there a way to insert multiple rows at a single time? Let me see if I can
explain.
I have an existing worksheet contain several hundreds rows on data. I want
to insert 16 new rows between each existing row of data. I can do this by
going to each row and inserting the rows but I was hoping there would be a
software 發表在 痞客邦 留言(0) 人氣(3)