I have a spreadsheet in place. I have a coulmn with the field name Event Descirption. I would like to know how do I create a box or a note that will show what type of info will be that particular column. In other words when anyone highlight that coulmn (Event Description)I want a box that...
I need help ASAP!
I have two cells as follows:
Cell A Cell B
Dell PFS Tools
Process
Training
Late Part
Additional Parts Required
Bandwidth
If can write a formula as follows =IF(A1 = "DELL PFS"...
I have about five cells in a spreadsheet where I want to create a fraction. For instance I want to know how to write in a cell in this format 10/10 or 5/10 etc.?
If Cell A is displaying street directions and I want Cell B to give me a value of true if there is anything in cell A how would I write the formula? So far I have =ISBLANK(A2). When I type that in I want to get back the value "TRUE" If there is nothing in CellA then I want to get the value...
How to create a formula in Excel that will give me certain characters? For instance if I have the city Alpharetta and I want to see the last 6 characters only how would I wirte the formula?
Column A
Fa Location Code(css) - Field name
10068082
10068651
10068760
10068788
10076550
10090280
10090940
10094492
Column B
DupFASiteNumber - Field name
100663-A
99965-A
103039-A
101289-A
80994-A
99952-A
93735-A
99173-A
Column C
Dup FA Action - Field name
In CSS Surviving Record
In CSS...
Look at the attached list below. I have this list in Excel and I was asked to create a formula so that MEDICAL, VISION and DENTAL can be known as MED, VIS and DEN respectively. How would I create a formula to reflect that? In other words i need to create a formula in this manner if cell A1 =...
I created a report in Crystal Reports that gave me the MTTA (Mean Time To Accept). I was able to group together tickets that have the MTTA in the desired time format DD:HH:MM:SS. Is the a way to calculate the AVERAGE of the grouped MTTA? When I exported the data to Excel with the MTTA already...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.