Home

unable to get same result while copying formula to rest of the cell

%3CLINGO-SUB%20id%3D%22lingo-sub-798789%22%20slang%3D%22en-US%22%3Eunable%20to%20get%20same%20result%20while%20copying%20formula%20to%20rest%20of%20the%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-798789%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Team%20%2C%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20Help%20as%20while%20copying%20this%20formula%20in%20different%20cells%20i%20am%20getting%20same%20result%20i.e.%20for%20%22%20abhishek%20Mishra%22%20for%20reference%20see%20the%20below%20photo%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F126503i15176949729537F1%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-798789%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-798887%22%20slang%3D%22en-US%22%3ERe%3A%20unable%20to%20get%20same%20result%20while%20copying%20formula%20to%20rest%20of%20the%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-798887%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F390417%22%20target%3D%22_blank%22%3E%40Navedkhan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMay%20be%20because%20of%20'Manual'%20calculation%20you%20are%20getting%20same%20data.%3C%2FP%3E%3CP%3EPlease%20check%20below%20and%20ensure%20that%20calculation%20option%20is%20selected%20as%20'Automatic'.%3C%2FP%3E%3CP%3EFile%20--%26gt%3B%20Options%20--%26gt%3B%20Formula%20--%26gt%3B%20Calculation%20options%20--%26gt%3B%20Automatic.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETauqeer%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-798949%22%20slang%3D%22en-US%22%3ERe%3A%20unable%20to%20get%20same%20result%20while%20copying%20formula%20to%20rest%20of%20the%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-798949%22%20slang%3D%22en-US%22%3Ehi%20%40tauqeer%20it's%20already%20set%20to%20automatic%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-798965%22%20slang%3D%22en-US%22%3ERe%3A%20unable%20to%20get%20same%20result%20while%20copying%20formula%20to%20rest%20of%20the%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-798965%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F390417%22%20target%3D%22_blank%22%3E%40Navedkhan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt's%20the%20same%20formula%20with%20copy%2Fpasting%2C%20thus%20same%20result%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-798967%22%20slang%3D%22en-US%22%3ERe%3A%20unable%20to%20get%20same%20result%20while%20copying%20formula%20to%20rest%20of%20the%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-798967%22%20slang%3D%22en-US%22%3Ei%20need%20to%20apply%20it%20on%20below%20cells%20%2C%20could%20you%20please%20help%20me%20how%20to%20do%20so%20%3F%3C%2FLINGO-BODY%3E
Highlighted
Navedkhan
Occasional Contributor

Hi Team , 

Please Help as while copying this formula in different cells i am getting same result i.e. for " abhishek Mishra" for reference see the below photo 

clipboard_image_0.png

4 Replies

Hi @Navedkhan 

 

May be because of 'Manual' calculation you are getting same data.

Please check below and ensure that calculation option is selected as 'Automatic'.

File --> Options --> Formula --> Calculation options --> Automatic.

 

Tauqeer

hi @tauqeer it's already set to automatic

@Navedkhan 

It's the same formula with copy/pasting, thus same result

i need to apply it on below cells , could you please help me how to do so ?
Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
205 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies