How to restore the option to delete row in the edit drop down menu in Excel Checkbook 2023
I just downloaded excel checkbook 2023 and am setting up my register. Originally I had the option to delete row in the edit drop down menu, but then after deleting a column I now only have the option to delete columns. I want to restore the option to delete a row instead of deleting columns. How do I do that?Long data copied to wide data
Hi, I am trying to do exam analysis and need to copy data from Excel (see image) into my home-made analysis sheet on Numbers mac (see image). The trouble is the exam board data is in a long format data sheet while my numbers table is in a wide format. I have tried copy/paste special/transposing but all that does is run all the candidate names horizontally along with the data horizontally (see image). What I am looking to try and do is have the candidate names go down in a column and have the data from each question run horizontally across from their name. How can I do that? Any help would be immensely appreciated - I have been at this for 2 hours now and am sure I could have just single-copied all the data by this point!!!
Concat and Concatenate problem
I have 203 column of data that I need to merge each row of that data into one column - tyring to merge street names for a list of addresses. I ahve done this before but the function does not seem to be working. Can someone help? What I tried: =Concat(c2,d2:c39,d39) then =concat(c2," ",d2) this was just to join first row of info then tried the same function with concatenate.
Excel (on Mac) Macro Highlight to the Top of a Column
Column F in the below table includes a blank cell. In a macro, I want to highlight cells F2 to F10. Since I could have any number of rows of data, I wrote the macro to get me to the last row of data, then highlight my way up using: Range(Selection, Selection.End(xlUp)).Select But since I could have any number of blanks in Column F, I had to repeat that line 12 times to be sure my highlighted range would always go to the top of the column. Is there a way to anchor the highlighting at the last row of data (as I have done), but then make E2 the "top" of my highlighted range?
Finding cell name given two inputs
Dear Sir, I have spread sheet like below. Frquency SIL 5 SIL3 SIL4 SILH SILH SILH 4 SIL2 SIL3 SIL4 SILH SILH 3 SIL1 SIL2 SIL3 SIL4 SILH 2 SIL0 SIL1 SIL2 SIL3 SIL4 1 SIL0 SIL0 SIL1 SIL2 SIL3 Consequence 1 2 3 4 5 Frequency 1 Consequence 3 SIL XXX I want to write formula in cell as shown as XXX, the formula should give me the result as SIL1, if i change Frequency and Consequency like say 2, 4 respetively then i should get SIL3. Please let me know what formulae or function i should use, roughly i know it is like INDEX and Match, i tried but INDEX take only column but my arry is in both column and rows like B2:E6. Regards.VLOOKUP Not Working with Time Values
I'm trying to use VLOOKUP to return a time period name (i.e., "Morning," "Afternoon," "Night," etc.) for corresponding time values. The formula works when I manually type the time value as I did in D2 below: However, for the time values in column A, VLOOKUP won't work. The formula is constructed exactly the same (see screenshot below). The values in column A are all Time values, and the values in my lookup table (H1:I:6) are all Time values. I'm at a loss as to why the VLOOKUP formula works when I manually type the time, but it doesn't work with the already existing time values in column A. They're all formatted as Time values. I appreciate any help or advice! Thank you.Help creating weighted average ranking
Hello, I have multiple lists of rankings of certain people and would like to create a weighted average "ranking" for each individual using those lists. I was able to do it with multiple SUMIF() and COUNTIF() functions but have to manually add in each new column as another function to the equation, and I have over 50 of these lists. Is there any way to do this a bit more elegantly? Current formula is: =(SUMIF($B$2:$B$11,G2,$A$2:$A$11)+SUMIF($C$2:$C$11,G2,$A$2:$A$11)+SUMIF($D$2:$D$11,G2,$A$2:$A$11))/(COUNTIF($B$2:$B$11,G2)+COUNTIF($C$2:$C$11,G2)+COUNTIF($D$2:$D$11,G2)) where G2 is the name of a person
