_
        

    


    
    


        
        

        

            
            

                
                


                

                    
                    

                        A1
                        — Hero_Sheet
                    


                    

                        
                        

                            

                                Your Spreadsheet

                                Problems, Solved

                                in Plain English.
                            


                            

                                I'm an AI chat assistant who lives and breathes spreadsheets. Describe what you're stuck on — a broken formula, messy data, a VBA macro that won't cooperate — and I'll walk you through the fix, step by step.
                            


                            

                                // Works with Excel & Google Sheets. Just tell me which one.
                            


                            

                                
                                    🧙 Ask Your First Question
                                
                                
                                    See how it works ↓
                                
                            

                        


                        
                        

                            

                                
                                

                                    Chat
                                    Sheet1
                                    +
                                


                                
                                

                                    
                                    

                                        

                                            
I have a column of names like "Smith, John" and I need to flip them to "John Smith". I'm in Google Sheets.

                                        

                                    


                                    
                                    

                                        

                                            
🧙 Spreadsheet Wizard

                                            
Nice one. Here's the formula — assuming your name is in A2:

                                            

                                                =TRIM(MID(A2,FIND(",",A2)+2,100))&" "&LEFT(A2,FIND(",",A2)-1)
                                            

                                            
How it works: FIND locates the comma. MID grabs everything after it (the first name). LEFT grabs everything before it (the last name). TRIM cleans up extra spaces.

                                        

                                    


                                    
                                    

                                        

                                            
What if some cells don't have a comma?

                                        

                                    


                                    
                                    

                                        

                                            
🧙 Spreadsheet Wizard

                                            
Smart edge case! Wrap it in an IF check:

                                            

                                                =IF(ISERROR(FIND(",",A2)), A2, ...formula above...)
                                            

                                            
If there's no comma, it just returns the name as-is. No errors. ✓

                                        

                                    

                                


                                
                                

                                    

                                        Try:
                                        "How do I VLOOKUP across sheets?"
                                        "Write me a VBA macro to..."
                                        "Explain SUMIFS vs SUMPRODUCT"
                                    

                                

                            

                        

                    

                

            


            
            

                

                    

                        B1:F1
                        — Example_Queries
                    


                    

                        Things You Can Actually Ask Me
                    

                    

                        // I'm an AI — I can't open your files or connect to your spreadsheet. But paste your formula, describe your data, or upload a screenshot, and I'll figure it out.
                    


                    
                    

                        
                        

                            

                                
                                Formulas
                                Row 1
                            

                            

                                
"My XLOOKUP returns #N/A even though I can see the value in the lookup range. What's going wrong?"

                                
→ I'll check for trailing spaces, data type mismatches, exact vs. approximate match, and other common traps.

                            

                        


                        
                        

                            

                                
                                Macros & Scripts
                                Row 2
                            

                            

                                
"I need a VBA macro that loops through all sheets in my workbook and copies row 1 to a summary sheet."

                                
→ I'll write the macro, comment every line, and explain how to paste it into the VBA editor.

                            

                        


                        
                        

                            

                                
                                Data Cleaning
                                Row 3
                            

                            

                                
"I imported 10,000 rows and the dates are a mix of MM/DD/YYYY and DD-Mon-YY. How do I standardize them?"

                                
→ I'll give you formulas or a script to parse both formats and convert to your preferred standard.

                            

                        


                        
                        

                            

                                
                                Pivot Tables
                                Row 4
                            

                            

                                
"I want a pivot table that shows monthly revenue by product category, with a running total column. Walk me through it?"

                                
→ I'll describe exactly which fields go where and how to add calculated fields for running totals.

                            

                        


                        
                        

                            

                                
                                Learn & Compare
                                Row 5
                            

                            

                                
"What's the difference between INDEX-MATCH and VLOOKUP? When should I use each?"

                                
→ I'll explain the tradeoffs clearly, with examples in both Excel and Sheets syntax.

                            

                        

                    

                

            


            
            

                

                    

                        C1:C3
                        — How_To_Use
                    


                    

                        Three Steps. No Setup.
                    


                    

                        
                        

                            

                                

                                    =ROW(1)
                                

                                
01

                                
Describe Your Problem

                                

                                    Type what you're trying to do. Paste the formula that's broken. Mention whether you're in Excel or Google Sheets. Upload a screenshot if it helps.
                                

                                

                                    > "My SUMIFS keeps returning 0..."
                                

                            

                        


                        
                        

                            

                                

                                    =ROW(2)
                                

                                
02

                                
Get the Solution + Explanation

                                

                                    I'll write the formula, macro, or step-by-step instructions. I'll explain why it works so you don't need to ask again next time. I'll flag differences between Excel and Sheets.
                                

                                

                                    > "Here's the fix — your criteria range was one row short..."
                                

                            

                        


                        
                        

                            

                                

                                    =ROW(3)
                                

                                
03

                                
Follow Up & Iterate

                                

                                    Something not quite right? Tell me. I'll adjust the formula, try a different approach, or break it down further. It's a conversation, not a one-shot answer.
                                

                                

                                    > "Almost! But I also need it to ignore blank rows..."
                                

                            

                        

                    

                

            


            
            

                

                    

                        D1:D4
                        — User_Feedback
                    


                    

                        What Chatting With the Wizard Is Actually Like
                    


                    

                        

                            

                                M
                                Marco
                            

                            
"I'd been fighting a nested IF for 45 minutes. Pasted it in, and within two messages it spotted the misplaced parenthesis AND suggested I use IFS instead. Genuinely helpful."

                        


                        

                            

                                S
                                Sarah
                            

                            
"I asked for a VBA macro and it actually explained each line. First time I've understood what `For Each ws in Worksheets` means instead of just copying blindly."

                        


                        

                            

                                D
                                Deepak
                            

                            
"Asked about Google Sheets QUERY function syntax — it gave me the formula AND told me where it differs from SQL. Way better than scrolling through forum threads."

                        

                    

                

            


            
            

                

                    

                        E1:E5
                        — FAQ_Sheet
                    


                    

                        Frequently Asked Questions
                    


                    

                        
                        

                            
                            
                        


                        
                        

                            
                            
                        


                        
                        

                            
                            
                        


                        
                        

                            
                            
                        


                        
                        

                            
                            
                        

                    

                

            


            
            

                

                

                    

                        

                            Z1
                            — Final_Cell
                        


                        

                            Stop Googling Formulas.

                            Ask the Wizard.
                        


                        

                            Whether it's a broken VLOOKUP at 2am or a macro you can't quite get right,
                            type your question and get a real answer — with an explanation, not just a formula to blindly paste.
                        


                        

                            I'm an AI, not a certified accountant — always double-check formulas with critical financial data.
                        


                        
                        

                            

                                fx
                                =
                                
                                
                            

                        


                        
                            🧙 Meet the Spreadsheet Wizard
                        

                        
Chat-based AI on AURVEK. No installs, no extensions.

                    

                

            

        


        
        

    


    

Related assistants